Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Unique with NotNull??

This is a discussion on Unique with NotNull?? within the SQL Server forums, part of the Databases category; Primary key is Clustered Index and not allows null value. Unique key is NonClustered Index allows one Null value Can I Define Unique key + Not Null is Equal to Primary ...

Geeks Talk > Databases > SQL Server Unique with NotNull??

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   06-08-2007

vcyogi Contributing Member   Join Date: Jun 2007 Location: Bangalore Posts: 32 Thanks: 3 Thanked 20 Times in 5 Posts

Unique with NotNull?? Primary key is Clustered Index and not allows null value. Unique key is NonClustered Index allows one Null value Can I Define Unique key + Not Null is Equal to Primary key ????

Sponsored Links

#2 (permalink)   06-08-2007

SQLTweety Junior Member   Join Date: May 2007 Posts: 16 Thanks: 0 Thanked 3 Times in 3 Posts

Re: Unique with NotNull?? Quote: Can I Define Unique key + Not Null is Equal to Primary key ???? Yes, Unique + NOT NULL is equivalent to primary key on a table ,though not explicitly declared. U can always use this column to retrieve a unique row from given table. HTH Regards,

#3 (permalink)   06-08-2007

hari.nattuva Contributing Member   Join Date: May 2007 Location: bangalore Posts: 65 Thanks: 3 Thanked 8 Times in 6 Posts

Re: Unique with NotNull?? I agreed with above answer given by one of our forum member.....

Geeks Talk > Databases > SQL Server

« Full Text Searching | hello i am new to this group »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
difference bet unique and distinct	smitai	Oracle Certification	2	06-18-2007 04:00 AM
Easy RSS Content Generator is an easy-to-use program for creating new unique content	JobHelper	Geeks Lounge	0	05-09-2007 11:50 AM
Actual Window Menu is the unique extension of standard window menu that provides adva	JobHelper	Geeks Lounge	0	04-25-2007 08:30 AM
How to find the unique id of mails through code	priya1985	Scripting	0	02-08-2007 03:30 AM
Usage of Unique Index	RyanJames	Oracle	2	10-13-2006 07:00 PM

All times are GMT -4. The time now is 01:47 PM.