What are primary keys and foreign keys?

Answer Posted / sudarsan

Primary key is a unique id for each table. This prevents
duplication of records. Each table can have a single
primary key. They can be refrenced by any tables as a
foreign key.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are partitioned views and distributed partitioned views?

583


how to take backup bcp out for a column in table in sql server?

1640


Define synonym?

731


Tell me what is difference between view and materialized view?

523


How would you use user_constraints table in DB?

592






How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

116


Do you know what is a linked server in sql server?

550


How to add code to the existing article (using improve article)?

593


What is the difference between char, varchar and nvarchar?

577


Tell me about normalization in DBMS.

583


How do I open a .db file?

483


What to perform pattern match with the like operator?

487


When would you use a before or after trigger?

492


What is msdb database? : SQL Server Architecture

541


When columns are added to existing tables, what do they initially contain?

628