Interested to Buy Any Domain ? << Click Here >> for more details...
What are constraints? Explain different types of
constraints?
- 26 Answers
- 139401 Views
- Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro, I also Faced
- E-Mail Answers
Answer Posted / rahul shrivastava
Constraints enable the RDBMS enforce the integrity of the
database automatically, without needing you to create
triggers, rule or defaults.
Types of constraints:
• PRIMARY KEY
• UNIQUE
• FOREIGN KEY
• CHECK
• NOT NULL
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. ( Entity integrity is an integrity rule which
states that every table must have a primary key and that
the column or columns chosen to be the primary key should
be unique and not null)
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.
A FOREIGN KEY constraint prevents any actions that would
destroy link 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.
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.
A NOT NULL constraint enforces that the column will not
accept null values. The not null constraints are used to
enforce domain integrity, as the check constraints.
| Is This Answer Correct ? | 10 Yes | 4 No |
Post New Answer View All Answers
When we should use and scope of @@identity?
How to create an inline table-valued function?
Explain what is the purpose of sql profiler in sql server?
How can you know if the row fetched from cursor is still valid in underlying table?
How can we remove orphan records from a table?
What do you understand by user-defined function in the sql server?
What are data resources?
explain the storage models of olap? : Sql server database administration
How can we delete Duplicate row in table?
How to store and query spatial data?
What are the restrictions applicable while creating views? : SQL Server Architecture
How do I open a .db file?
How to execute a sql statement using mssql_query()?
Characterize join and name diverse sorts of joins?
What is the new security features added in sql server 2014? : sql server security
