SQL ALTER TABLE Statement
SQL ALTER TABLE Statement
The ALTER TABLE statement is used to add, delete, or modify columns in an existing table.
The ALTER TABLE statement is also used to add and drop various constraints on an existing table.
__________________________________...See more
______
ALTER TABLE - ADD Column
To add a column in a table, use the following syntax:
ALTER TABLE table_name
ADD column_name datatype;
The following SQL adds an "Email" column to the "Customers" table:
Example
ALTER TABLE Customers
ADD Email varchar(255);
ALTER TABLE - ALTER/MODIFY COLUMN
Views: 1015
Added: 4 years ago
SQL ALTER TABLE Statement.docx
Download
Suggested Creators
Answer the Question