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
Define right outer join?
What is the order in which the sql query is executed?
How to choose all records from the table?
How to list all dsn entries on your local machine using odbc_data_source()?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
How column data types are determined in a view?
What is the difference between nvl and nvl2?
What is user-defined scalar function?
What is a cube? : sql server analysis services, ssas
Tell me what is fill factor?
What is transact-sql ddl trigger?
What is sql server profiler trace data file?
How can you find out which stored procedures are recompiling?
What is filestream?