GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  SQL Server

 Print  |  
Question:  Define Unique Key in SQL Server

Answer: How to define unique key in table? Is it possible to define one primary key and one unique key in a single table?


March 03, 2008 14:46:26 #1
 LGSGEEK   Member Since: March 2008    Total Comments: 3 
RE: Define Unique Key in SQL Server
 
You can make one (or more) columns unique in a table by defining a UNIQUE NONCLUSTERED index on the column.
     

 

Back To Question