What is Primary key and foreign key? Give an example
Answer Posted / brajesh kumar srivastava
Primary key enforce uniqueness of column and deny to allow
null values to this column and enforce referential data
integrity constraint to other table column which is call
foreign key.
Foreign key column may contain null value
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the advantages of policy management?
What is a fan-out query in SQL Azure?
What are the steps you will take to improve the performance of a poor performing query?
What is an etl file?
How to store and query spatial data?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Write the syntax for stuff function in an sql server?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is explicit cursors?
What are cascading parameters in ssrs reports?
Why would you use sql agent?
How to update a field in SQL after ALTERING a row?
Explain the steps to use transact-sql cursor?
How will you find out if there are expensive SQL statements running or not?
Why do we use stored procedures in sql server?