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. ________________________________________ 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

SQL ALTER TABLE Statement +4 more

by yash sharma

Stash 0

1 Attachment 4 years ago