1. 增加列
syntax:ALTER TABLE tablename ADD columnname datatype [是否可空] [默认值]
eg:ALTER TABLE t_user ADD email NOT NULL DEFAULT ''
2. 删除列
syntax: ALTER TABLE tablename DROP COLUMN columnname
eg: ALTER TABLE t_user DROP COLUMN email
note:如果被删除的列有约束信息,需要先删除对应于该列的约束信息,删除列的语句才能执行成功
3. 修改列
修改列名称(执行sp_rename)
syntax: EXEC sp_rename ‘tablename.columnname’,'newcolumnname','column'
eg: EXEC sp_rename ‘t_user.email’,'emailaddress','column'
修改数据类型默认值等
syntax: ALTER TABLE tablename ALTER COLUMN columnname [是否可空] [默认值]
eg:ALTER TABLE t_user ALTER COLUMN email NULL DEFAULT 'TEST@163.COM'