create database ma_bd create table persons id int not null person_name varchar 50 not null birth_date date phone char 15 not null constraint pk_persons primary key id drop table persons alter table ancien_nom rename to nouveau_nom alter table nom_table modify nom_colonne type_donnees alter table ma_table add column colonne_1 serial primary key alter table students add column last_name varchar 50 not null alter table table_name drop column column_name alter table table_name add primary key column_name column_name alter table nom_table rename column ancien_nom_colonne to nouveau_nom_colonne insert into table_name column_name values value drop table customers delete from table_name where condition truncate table categories truncate table_1 table_2 table_3 insert into table_name column_1_name column_2_name values value_1 value_2 insert into nom_table values value1 value2 value3 insert into customers customername contactname address city postalcode country values cardinal tom b erichsen skagen 21 stavanger 4006 norway greasy burger per olsen gateveien 15 sandnes 4306 norway tasty tee finn egan streetroad 19b liverpool l1 0aa uk update table_name set column1 value1 column2 value2 where condition update customers set score 0 where id 6 delete from customers where id greater than 5