Home Forums SQL Server 7,2000 General unique values RE: unique values
5409045121009-7368
SSCoach
Points: 15740
More actions
June 25, 2003 at 12:49 am
#462921
Is this what you want?
CREATE TABLE [dbo].[Test] (
[ColA] [int] NOT NULL ,
[ColB] [varchar] (5) NOT NULL ,
[ColC] [money] NOT NULL)
GO
ALTER TABLE [dbo].[Test] WITH NOCHECK ADD
CONSTRAINT [PK_Test] PRIMARY KEY CLUSTERED ([ColA],[ColB])