（一）SQL Server T-SQL基础语法——表操作

1、新建表格

create table TABLE_NAME
(
	data_type col_name [default value]|[identity(offset,step)]|[not null]
	|[primary key]|[check(col_name=... or col_name = ... or....)]
)

2、修改表格
表约束添加、删除
1）添加
主键约束

alter table [table_name] add constraint **primary key**(col_name)

外键约束

alter table [t1] add constraint foreign key(t1.col_name) references t2(related_col_name)

唯一约束

alter table [table_name] add constraint unique(col_name)

检查约束

alter table [table_name] add constraint check([col_name in(val1,val2,val3...)]|col_name=val1 or col_name=val2)

2）删除

alter table 表名 drop constraint 约束名;

---

2、表字段
1）添加字段

alter table [table_name] add [col_name] type [constraint]

2）修改字段名

exec sp_rename '[table].[col_name]','[new_col_name]'

3）修改字段类型

**alter** table [table_name] **alter** column [col_name] type [constraint]

4）删除字段

alter table [table_name] drop col_name