SQL serve 建表与修改操作

–建表

create table tablename
(column name varchar(50) null|not null primary key|unique|default|foreign key references|check,
......
constraint xxxxxxname  primary key()|unique()|default 默认值 for |foreign key() references table()|check() 
......
)

–改表

alter table tablename
{
alter column name 数据类型 [not null|null]
add column|constraint
drop column|constraint
check|nocheck constraint
}

–删除表

drop table tablename

–插入行

insert into tablename
values() | select

–修改行

update table
set column = 修改值
where 筛选条件

–删除行

delete from tablename
where 筛选条件