What is Primary key and foreign key? Give an example
Answer Posted / vipin
Primary key which enforce the uniqueness in each row og table .
Foreign key win which the existing value in table must be there in other table .
diffrence is that PK does not allow Null Values anf FK allow null values
| Is This Answer Correct ? | 17 Yes | 2 No |
Post New Answer View All Answers
How to define and use table alias names in ms sql server?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is the use of floor function in sql server?
When would you use it?
What is the difference between truncate and delete commands?
What is 2nf in normalization?
What is update_statistics command?
How is SQL Azure different than SQL server?
How to modify an existing user defined function?
what is nonclustered index
What are group functions in query statements in ms sql server?
what is the information that can be stored inside a bit column? : Sql server database administration
What is the use of keyword with encryption. Create a store procedure with encryption?
Explain the steps to use transact-sql cursor?
What is the ‘fillfactor’?