--员工表
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EMPLOYEE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[EMPLOYEE]CREATE TABLE [dbo].[EMPLOYEE] (
[EMP_ID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , --员工编号
[EMP_NAME] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , --员工姓名
[EMP_SEX] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , --员工性别
[EMP_CARID] [char] (10) COLLATE Chinese_PRC_CI_AS NULL --员工身份证号
) ON [PRIMARY]--员工表主建
ALTER TABLE [dbo].[EMPLOYEE] WITH NOCHECK ADD
CONSTRAINT [PK_EMPLOYEE] PRIMARY KEY CLUSTERED
(
[EMP_ID]
) ON [PRIMARY]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EMPLOYEE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[EMPLOYEE]CREATE TABLE [dbo].[EMPLOYEE] (
[EMP_ID] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , --员工编号
[EMP_NAME] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , --员工姓名
[EMP_SEX] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , --员工性别
[EMP_CARID] [char] (10) COLLATE Chinese_PRC_CI_AS NULL --员工身份证号
) ON [PRIMARY]--员工表主建
ALTER TABLE [dbo].[EMPLOYEE] WITH NOCHECK ADD
CONSTRAINT [PK_EMPLOYEE] PRIMARY KEY CLUSTERED
(
[EMP_ID]
) ON [PRIMARY]
或create table a
(a int ,b int ,primary key(a,b)----a,b復合主鍵
SendID 是主键