增加列:
alter table tableName add columnName varchar(30)
修改列类型:
alter table tableName alter column columnName varchar(4000)
修改列的名称:
EXEC sp_rename 'tableName.column1' , 'column2' (column1列名修改为column2)
删除列:
alter table tableName drop column columnName
附加数据库:
CREATE DATABASE AdventureWorks2013 ON (FILENAME = 'D:\Database\A.mdf'),
(FILENAME = 'D:\Database\A.ldf') FOR ATTACH
查询列名及说明
select a.name,value from syscolumns a,sys.extended_properties g
where a.id=(select max(id) from sysobjects where xtype='u' and name='表名')
AND a.id = g.major_id and a.colid=g.minor_id