Hi,
I have a table as below
CREATE TABLE [dbo].[tblLocationMaster](
[LocationID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[LocationName] [varchar](50) NOT NULL,
[Description] [varchar](500) NULL,)
I want to add a constraint on LocationName so that duplicate values do not get saved in table... How to do this?
Loading
Pravin MorePosted Sep 19, 2011, 8:34 AM
Thanx,
Pravin.
Dorababu MekaPosted Sep 19, 2011, 7:06 AM
Nethra R SPosted Sep 19, 2011, 6:45 AM
Pravin MorePosted Sep 19, 2011, 5:01 AM
here is your modified query.....
CREATE TABLE [dbo].[tblLocationMaster](
[LocationID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[LocationName] [varchar](50) NOT NULL UNIQUE,
[Description] [varchar](500) NULL,)
hope this will solve ur problem..
Thanx ,
Pravin
Dorababu MekaPosted Sep 19, 2011, 3:54 AM