What is the use of Alter Table command in database? Anonymous User229216-Oct-2010mssql servermssql server Updated on 21-Sep-2020
Anonymous User
10-Nov-2010The SQL ALTER TABLE command is used to add, delete or modify columns in an existing table.
Use of ALTER command in database
Alter command is used for change the column name, add column, add constraint, and change the datatype.
Syntax: Add Column name
Syntax: Delete a Column
Syntax: Change Column Name
Pushpendra Singh
09-Nov-2010To add a column in a table, use the following syntax:
ALTER TABLE table_name
ADD column_name datatype