CREATE TABLE [dbo].[line] (
[line_id] [int] IDENTITY (1, 1) NOT NULL ,
[line_name] [varchar] (20) NOT NULL ,
[portid_start] [int] NOT NULL ,
[portid_end] [int] NOT NULL ,
)
GO
ALTER TABLE [dbo].[line] WITH NOCHECK ADD
CONSTRAINT [line_id] PRIMARY KEY CLUSTERED
(
[line_id]
) ON [PRIMARY]
GO
这个表是老的,里面有很多数据,现在的问题是事实上本应该将portid_start和portid_end两个字段设为双主键才对,但是那样的话程序将会有大改动,有什么办法在保持原有的line_id主键的同时,限制portid_start和portid_end,不允许有两条纪录在这两个字段中的值相同?请指点!
---------------------------------------------------------------
CREATE UNIQUE NONCLUSTERED INDEX UQ_line
ON line(portid_start,portid_end)
---------------------------------------------------------------
建立唯一索引
---------------------------------------------------------------
建立unique约束