Answer Posted / suresh kaudi
Primary Key: Not allow null values,when we make primary key
automatically create cluster index,primary key we make
other foreign key.
Unique key: allow one null value,we can't make it foreign
key to other table.here we cane make only non-cluster index
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you explain the disadvantages/limitation of the cursor?
can we have a nested transaction? : Sql server database administration
What is difference between cte and view?
Relational calculus is what type of language?
What do you understand by user-defined function in the sql server?
what is a sub-report?
How to use subqueries with the in operators in ms sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What are the underflow and overflow behaviors on float literals?
What is difference between sql and sql server?
How to check if a table is being used in sql server?
How do I start sql server agent automatically?
Explain what are the different index configurations a table can have?
What are the types of database schema? : sql server analysis services, ssas
What is the security model used in sql server 2005?