SQL ALTER Statement: Syntax & Examples

1 year ago
Liam
1 minute

In SQL, the ALTER statement is used to modify the structure of an existing database table, such as adding, deleting, or modifying columns, changing the table name, and altering table constraints.

Here is the general syntax for the ALTER statement:

ALTER TABLE table_name
ADD column_name datatype;

ALTER TABLE table_name
DROP COLUMN column_name;

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

ALTER TABLE table_name
RENAME TO new_table_name;

The specific implementation method depends on the specific operation to be performed, and the table structure can be modified according to the chosen syntax as needed.

bannerAds