what is for foreign key ??

Answer Posted / a.ganesh

it's reduce the repeated data in the database
.I think this is main advantage and the recode can't
directly delete from Parent Table

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is INSTEAD OF trigger directly applicable to Table ?

575


Is truncate autocommit?

565


Explain some stored procedure creating best practices or guidelines?

525


What is the difference between ‘having’ clause and a ‘where’ clause?

553


How to verify the port number of the sql server?

561






What were the latest updates to SQL Azure service?

94


How do users use Report Builder with SQL Server data sources?

119


Explain different types of Normalization.

599


What is the use of “join” in sql server?

574


What are the ways available in sql server to execute sql statements?

572


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2474


What is indexing and its types?

532


Please illustrate physical database architecture? : SQL Server Architecture

535


How can change procedure in sql server?

526


How to divide query output into multiple groups with the group by clause in ms sql server?

570