ALTER : Modifier une table
ADD : Ajouter une colonne.
<![CDATA[
ALTER TABLE maTable ADD COLUMN maColonne;
]]>
<![CDATA[
ALTER TABLE client ADD tel varchar(10) not null;
ALTER TABLE client ADD PRIMARY KEY (id);
ALTER TABLE client ADD FOREIGN KEY (cp) REFERENCES societe (id);
ALTER TABLE client ADD INDEX (cp);
]]>
DROP : Supprimer une colonne
<![CDATA[
ALTER TABLE maTable DROP COLUMN maColonne;
]]>
ALTER TABLE DROP: Suppression
<![CDATA[
ALTER TABLE client DROP tel;
ALTER TABLE client DROP PRIMARY KEY;
ALTER TABLE client DROP FOREIGN KEY (cp);
ALTER TABLE client DROP INDEX cp;
]]>
