ALTER TABLE

ALTER TABLE is used to update the schema of an existing table. To create a new table, use CREATE TABLE. See Lesson 17, "Creating and Manipulating Tables," for more information.

ALTER TABLE tablename
(
   ADD|DROP   column   datatype   [NULL|NOT NULL] [CONSTRAINTS],
   ADD|DROP   column   datatype   [NULL|NOT NULL] [CONSTRAINTS],
   …
);

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.217.84.171