HotRecruiter.Com

Sign up or Sign in | Share
JOBS
or
RESUMES
or
PEOPLE
SEARCH  
 
ClearMyBench
Welcome, Guest
Please Login or Register.    Lost Password?
ClearMyBench Technology Databases SQL Server
Re:SQL (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
  • Page:
TOPIC: Re:SQL
#5745
venkatesh (User)
Platinum Boarder
Posts: 2204
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hyd Birthdate: 1985-10-06
SQL 3 Years, 10 Months ago Karma: 0  
What is data integrity? Explain constraints?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#5747
venkatesh (User)
Platinum Boarder
Posts: 2204
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hyd Birthdate: 1985-10-06
Re:SQL 3 Years, 10 Months ago Karma: 0  
Data integrity is an important feature in SQL Server. When used properly, it ensures that data is accurate, correct, and valid. It also acts as a trap for otherwise undetectable bugs within applications.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#5749
venkatesh (User)
Platinum Boarder
Posts: 2204
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hyd Birthdate: 1985-10-06
Re:SQL 3 Years, 10 Months ago Karma: 0  
A PRIMARY KEY constraint is a unique identifier for a row within a database table. Every table should have a primary key constraint to uniquely identify each row and only one primary key constraint can be created for each table. The primary key constraints are used to enforce entity integrity.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#5750
venkatesh (User)
Platinum Boarder
Posts: 2204
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hyd Birthdate: 1985-10-06
Re:SQL 3 Years, 10 Months ago Karma: 0  
A UNIQUE constraint enforces the uniqueness of the values in a set of columns, so no duplicate values are entered. The unique key constraints are used to enforce entity integrity as the primary key constraints.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#5751
venkatesh (User)
Platinum Boarder
Posts: 2204
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hyd Birthdate: 1985-10-06
Re:SQL 3 Years, 10 Months ago Karma: 0  
A FOREIGN KEY constraint prevents any actions that would destroy links between tables with the corresponding data values. A foreign key in one table points to a primary key in another table. Foreign keys prevent actions that would leave rows with foreign key values when there are no primary keys with that value. The foreign key constraints are used to enforce referential integrity.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#5752
venkatesh (User)
Platinum Boarder
Posts: 2204
graphgraph
User Offline Click here to see the profile of this user
Gender: Male Location: Hyd Birthdate: 1985-10-06
Re:SQL 3 Years, 10 Months ago Karma: 0  
A CHECK constraint is used to limit the values that can be placed in a column. The check constraints are used to enforce domain integrity.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
  • Page:
get the latest posts directly to your desktop
 
logo footer   Copyright 2009 - 2013 HotRecruiter.Com - All Rights Reserved