复合主键和索引

创建银联表 用到了复合主键和索引

use smartview --创建银联交易表 SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[unionpaytran] ( ltranid [char](8) COLLATE Chinese_PRC_CI_AS NOT NULL,--复合主键的标示 ltrandate [char](8) COLLATE Chinese_PRC_CI_AS NOT NULL,--交易日期 ltrantime [char](6) COLLATE Chinese_PRC_CI_AS NOT NULL,--交易时间 tranaccount [char](20) COLLATE Chinese_PRC_CI_AS NOT NULL,--银联流水号 trantype [char](4) COLLATE Chinese_PRC_CI_AS NULL,--交易类型 trancode [char](6) COLLATE Chinese_PRC_CI_AS NOT NULL,--交易码 tranamt [bigint] NULL,--交易金额 currtype [char](3) COLLATE Chinese_PRC_CI_AS NULL, --币种 termno [char](8) COLLATE Chinese_PRC_CI_AS NOT NULL,--终端号 retcode [char](2) COLLATE Chinese_PRC_CI_AS NULL,--返回码 tfraccount [char](20) COLLATE Chinese_PRC_CI_AS NULL,--转入账号 remark [char](30) COLLATE Chinese_PRC_CI_AS NULL,--预留域 remark2 [char](30) COLLATE Chinese_PRC_CI_AS NULL,--预留域2 remark3 [char](30) COLLATE Chinese_PRC_CI_AS NULL,--预留域3 CONSTRAINT [pk_unionpaytran] PRIMARY KEY CLUSTERED --创建复合主键 ( [ltrandate]asc, [ltrantime]asc, [tranaccount]asc, [trancode]asc, [termno]asc )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] )ON [PRIMARY] GO SET ANSI_PADDING OFF --创建交易日期　银联流水号 终端号组成的索引 CREATE INDEX unionpay_index on unionpaytran(ltrandate,tranaccount,termno)