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 difference between left and right outer join?
How you can add messages to the nt event log from within a stored procedure?
What is user-defined function?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How to optimize stored procedure optimization?
What is update_statistics command?
How to get a list of columns in a view using the "sp_columns" stored procedure?
Explain differences between web edition and business edition?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How to achieve Paging of records in SQL SERVER?
Do you know the cursor types?
How exceptions can be handled in sql server programming?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Explain the phases a transaction has to undergo?