Answer Posted / sunil kumar mishra
Primary key is a particular coloum that is unique in every
tuple is called primary key and ofenly it does not support
null values since it is used to uniquely identitfy row in a
table(Relation) and automatically does go to replace into
clustered index and support distinct value and Each table
should have a primary key, and each table can have only one
primary key.(Primary keys must contain unique values)
Unique value-
Unique values is same, in some manner, primary key since
You can have many UNIQUE constraints per table but primaty
key kan have one in each table.it support nonClustered
index.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are different types of raid levels?
What is save transaction and save point?
What is the difference between functions and scalar functions?
How do I view a script in sql server?
What is a view and what are its advantages?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
What is database architecture? : SQL Server Architecture
Explain syntax for disabling triggers?
Why is normalisation important?
What is difference between rownum and rowid?
What is indexed view? How to create it?
You want to implement the one-to-many relationship while designing tables. How would you do it?
what is a live lock? : Sql server database administration
How many types of the database links?
Which table keeps information about stored procedures?