代码
if
not
exists
(
select
*
from
dbo.sysobjects
where
id
=
object_id
(N
'
[dbo].[主键名称]
'
)
and
OBJECTPROPERTY
(id, N
'
IsPrimaryKey
'
)
=
1
)
ALTER
TABLE
[
dbo
]
.
[
表名
]
WITH
NOCHECK
ADD
CONSTRAINT
[
主键名
]
PRIMARY
KEY
CLUSTERED
(
[
字段
]
ASC
)
WITH
FILLFACTOR
=
90
ON
[
PRIMARY
]
转载于:https://www.cnblogs.com/lfzwenzhu/archive/2010/10/19/1855483.html
相关资源：sql server创建复合主键的2种方法
