sql server 2008建表语句

create table dept
(
 d_id int constraint pk_dept primary key, --主键

qita char()

 )

create table emp
(
 d_id int constraint fk_dept_emp foreign key references dept(d_id) --外键
)