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
How many joins in sql server?
How to filter out duplications in the returning rows in ms sql server?
What is the syntax to execute the sys.dm_db_missing_index_details?
What are the types of subquery?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Can a database be shrunk to 0 bytes, if not, why?
What is difference between sql and sql server?
What stored by the msdb? : sql server database administration
What are the 2 types of classifications of constraints in the sql server?
what is an extended stored procedure? : Sql server database administration
Why use view instead of a table?
between cast and convert which function would you prefer and why?
What structure can you implement for the database to speed up table reads?
What is dbcc command in sql server?
what is difference between NULL and ISNULL in SQL Server 2008?