SQL TABLE Keyword

❮ SQL Keywords

command creates a new table in the database. The following SQL creates a table called "Persons" that contains five columns: PersonID, LastName, FirstName, Address, and City:

( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255),

A copy of an existing table can also be created using CREATE TABLE. The following SQL creates a new table called "TestTables" (which is a copy of the "Customers" table):

SELECT customername, contactname

command adds, deletes, or modifies columns in a table.

command also adds and deletes various constraints in a table. The following SQL adds an "Email" column to the "Customers" table:

command deletes a table in the database. The following SQL deletes the table "Shippers":

Be careful before deleting a table. Deleting a table results in loss of all information stored in the table!