SqlServer2005

create table Department ( cDepartmentCode char(4) constraint dt_pk primary key, vDepartmentName varchar(25) , vDepartmentHead varchar(25), vLocation varchar(20) )