Shulou(Shulou.com)06/01 Report--

SQL statement to add columns, modify columns, delete columns

1. Add columns:

Alter table tableName add columnName varchar (30)

2.1. Modify the column type:

Alter table tableName alter column columnName varchar (4000)

2.2. Change the name of the column:

EXEC sp_rename 'tableName.column1',' column2' (change the name of the column1 column named tableName to column2)

3. Delete the column:

Alter table tableName drop column columnName

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.