Generally speaking, it is the first stap of learning the SQL serves.
Comand:
- create table table_name(
column_name datatype [not null],
column_name datatype [not null primary key],
…);
Obviously, it is the whole structure for table creating precedure. - alter table table_name
add column column_name datatye;
add a field and declear its dataype. - alter table table_name
add/drop primary key (column_name);
add/drop(delete) a primary key.