Interested to Buy Any Domain ? << Click Here >> for more details...
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 is the benefit of normalization?
What objects does the fn_my_permissions function reports on? : sql server security
Define model database?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
When cursors are useful?
What happens if null values are involved in comparison operations?
What is a trace frag?
What is the purpose of floor function?
What happens if the update subquery returns multiple rows in ms sql server?
what stored procedure can you use to display the current processes? : Sql server administration
How does a profiler work?
How to provide values to user defined function parameters?
What is change tracking in sql server?
List the ways in which dynamic sql can be executed?
Explain an automatic checkpoint
