Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of placing primary key and foreign key
constrains on columns.
- 4 Answers
- 8294 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / rajendraprasad cherukuri
To segregate the data in different tables belongs to a
particular entity so that data can be retrieved when
required more economically and in a faster way.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is foreign key unique?
How to rebuild the master database?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Do you know the cursor optimization tips?
Which data type columns are the best candidates for full-text indexing?
what are the Prerequisites for Replication?
Where to find ntwdblib.dll version 2000.80.194.0?
Can binary strings be used in arithmetical operations?
What is NOT NULL Constraint in sql server 2012?
How raid can influence database performance?
How do I view a stored procedure in sql server?
What are the restrictions applicable while creating views? : SQL Server Architecture
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What are sql servers used for?
What is proper subset of candidate key?
