–建表
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 筛选条件