SQL
MANAGE TABLES
CREATE A NEW TABLE
GENERAL SYNTAX
create table <table_name> (
<col_name_1> <data_type>,
<col_name_2> <data_type>,
<col_name_1> <data_type>
);
CREATE A NEW TABLE
EXAMPLE
create table customer (
customer_id INTEGER,
first_name VARCHAR(50),
last_name VARCHAR(50),
birthdate DATE
);
CREATE A NEW TABLE
MAKE CODE MORE ROBUST
create table if not exists customer (
customer_id INTEGER,
first_name VARCHAR(50),
last_name VARCHAR(50),
birthdate DATE
);
ADD KEYS TO A TABLE
PRIMARY KEY
alter table <table_name>
add primary key (<col_name_pk>);
Example:
alter table customer
add primary key (customer_id);
ADD KEYS TO A TABLE
FOREIGN KEY
alter table <table_name>
add foreign key (<col_name_fk>)
references <ref_table_name>(<col_name_pk>);
Example:
alter table order
add foreign key (customer_id)
references customer(customer_id);