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
How can I create a report based on a query? : sql server management studio
Define msdb database?
What is a derived table?
How to find out the list schema name and table name for the database?
What is a Join and explain its types?
What is the difference between ‘having’ clause and a ‘where’ clause?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What are the properties of the transaction?
Explain collation?
How do you delete duplicate rows in sql server?
how to create “alternate row colour”?
What is the difference between a stored procedure and a user defined function?
Would you store your query in a ssrs report or a database server? State the reason why?
What is normalization process?
What are the approximate numeric data types?
