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

Can we write trigger for view?

724


What are dml (data manipulation language) statements in ms sql server?

734


Explain the disadvantages of cursors?

762


How does index makes search faster?

763


How to list all columns in a table using odbc_columns()?

727






How to create and drop temp table in sql server?

769


What is an example of a foreign key?

695


How to verify a login name with sqlcmd tool?

789


What is the usage of the sign function?

707


Mention the differences between sql server and mysql.

680


What is 3nf normalization form?

760


What is a periodical index?

650


Your table has a large character field there are queries that use this field in their search clause what should you do?

691


How are the exceptions handled in sql server programming?

757


What are xml indexes?

697