Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 88462 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohan
Constraint is nothing but set of rules or restrictions on a column,in order to achieve business requirements.
There are five types of constraints,
they are
1.primary key
2.unique key
3.not null
4.check
5.foreign key
These constraints also called data integrity constraints.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is page-level compression?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is the default Port No on which SQL Server listens?
How to rebuild master databse?
What is difference between join and natural join?
How do I find information about the install locations for the various instances running on a computer?
what is a self join? Explain it with an example? : Sql server database administration
Explain few examples of RDBMS?
What is a derived table?
Which are the important points to note when multilanguage data is stored in a table?
What is a coalesce function?
Why should one not prefix user stored procedures with ‘sp_’?
How to select all columns of all rows from a table with a select statement in ms sql server?
What are examples of triggers?
How to enter date and time literals in ms sql server?
