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 different ways to return the rowcount of a table?
What is named query? : sql server analysis services, ssas
How to enter comments in transact-sql statements?
What are the types of resultset?
Why functions are used in sql server?
What is the difference between getdate and sysdatetime?
What is isnull() operator?
What is the difference between a primary key and a unique key? Are they the same?
how many no of arguments can be passed in procedures and functions
What are the extra roles available in msdb? : sql server security
Why is the need for data conversion transformations?
How do I find the sql server database version?
if no size is defined while creating the database, what size will the database have? : Sql server administration
Explain raiserror in sql server?
Explain few examples of stored procedure over triggers?