What are constraints? Explain different types of
constraints?
Answer Posted / k.swathi
constraint is a mechanism which is used to stop the data entered by the end user by implementing bussiness rules.
contraint are 6 types
1)unique
2)primary key
3)check
4)null
5)not null
6)foreign key(refferential key)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why should you use or avoid select * statements?
What is raid and what are different types of raid levels?
what are user defined datatypes? : Sql server database administration
Why I have to use stored procedures?
How do I perform an unattended install of sql server 2000?
What are the properties of the relational tables?
How to write an inner join with the where clause in ms sql server?
What is bcnf normalization form?
can SSRS reports Cache results?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Name 3 ways to get an accurate count of the number of records in a table?
Explain system views?
What does REVERT do in SQL Server 2005?
What are four major operators that can be used to combine conditions on a where clause?