if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USER]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[USER]
GO
CREATE TABLE USER_TABLE
(
ID INT NOT NULL ,
OTHER_ID INT NOT NULL ,
SEC_ID INT NOT NULL ,
USER_NAEM CAHR(10) NOT NULL,
........
CONSTRAINT [PK_user_table] PRIMARY KEY CLUSTERED
(
[id],
[OTHER_ID],
[SEC_ID]
) ON [PRIMARY]
)ON [PRIMARY]
drop table [dbo].[USER]
GO
CREATE TABLE USER_TABLE
(
ID INT NOT NULL ,
OTHER_ID INT NOT NULL ,
SEC_ID INT NOT NULL ,
USER_NAEM CAHR(10) NOT NULL,
........
CONSTRAINT [PK_user_table] PRIMARY KEY CLUSTERED
(
[id],
[OTHER_ID],
[SEC_ID]
) ON [PRIMARY]
)ON [PRIMARY]
这位高手,能说明一下吗?我不太董SQL语句的,
CONSTRAINT [PK_user_table] PRIMARY KEY CLUSTERED 是什么呀?
谢谢
PRIMARY KEY 表示主键
CLUSTERED表示是聚集索引。
alter table user_table add constraint pk_name primary key NONCLUSTERED(id,...)如果表已建好并且已经有了primary key,则要先把该primary key 删除:
alter talbe user_table drop constraint pk_name
(
ID INT NOT NULL ,
OTHER_ID INT NOT NULL ,
SEC_ID INT NOT NULL ,
USER_NAEM CAHR(10) NOT NULL,
........
CONSTRAINT [PK_user_table] PRIMARY KEY CLUSTERED
(
[id],
[OTHER_ID],
[SEC_ID]
) ON [PRIMARY]
)ON [PRIMARY]建表时就指定id,other_id,sec_id三个字段一起作为主键
(
ID INT NOT NULL,
OTHER_ID INT NOT NULL,
SEC_ID INT NOT NULL,
USER_NAEM CAHR(10) NOT NULL
........
primary key (id,other_id,sec_id)
)
ON MESSAGE
GO