Statements to modify table structure in sql

You can modify the table structure through the ALTER TABLE statement. The specific operations are: add a column: ALTER TABLE table_name ADD column_name data_type; delete a column: ALTER TABLE table_name DROP COLUMN column_name; modify a column: ALTER TABLE table_name ALTER COLUMN column_name NEW_DATA_TYPE; Add constraints: ALTER TABLE table_name ADD CONSTRAINT constr

SQL statement to modify the table structure

In SQL, you can Modify the table structure through the ALTER TABLE statement. This statement can be used to add, delete, or modify a table's columns, constraints, or indexes.

Add column

ALTER TABLE table_name ADD column_name data_type;

For example:

ALTER TABLE customers ADD phone_number VARCHAR(10);

Delete column

ALTER TABLE table_name DROP COLUMN column_name;

For example:

ALTER TABLE customers DROP COLUMN age;

Modify columns

ALTER TABLE table_name ALTER COLUMN column_name NEW_DATA_TYPE;

For example:

ALTER TABLE customers ALTER COLUMN name VARCHAR(50);

Add constraints

ALTER TABLE table_name ADD CONSTRAINT constraint_name [CONSTRAINT_TYPE];

For example:

ALTER TABLE orders ADD CONSTRAINT FK_customer FOREIGN KEY (customer_id) REFERENCES customers (customer_id);

Delete constraints

ALTER TABLE table_name DROP CONSTRAINT constraint_name;

For example:

ALTER TABLE orders DROP CONSTRAINT FK_customer;

Add index

ALTER TABLE table_name ADD INDEX index_name (column_name);

For example:

ALTER TABLE customers ADD INDEX idx_name (name);

Delete index

ALTER TABLE table_name DROP INDEX index_name;

For example:

ALTER TABLE customers DROP INDEX idx_name;

By using these ALTER TABLE statements, the table structure can be easily modified to adapt to changing data needs .

The above is the detailed content of Statements to modify table structure in sql. For more information, please follow other related articles on the PHP Chinese website!