what is Constraint? How many types of constraints in SQL ?

Answer Posted / balamurugan

only five constraint in sql server

Types of Constraints are:
1)Not Null
2)Unique
3)Foreign Key
4)Check
5)Default.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between rank and dense_rank?

697


Why truncate is ddl?

835


How to trouble shoot if unable to connect SQL Server

1697


What is the difference between NOROW and LOCKROW?

2494


Can we use where clause in union?

806


What are the limitations/drawbacks or ssrs 2008 r2?

107


What is the difference between left and right outer join?

731


can we have a nested transaction? : Sql server database administration

711


Can a table have 2 primary keys?

737


Explain the xml support sql server extends?

824


What is merge statement?

823


Explain how to send email from sql database?

744


Which sql server table is used to hold the stored procedure scripts?

817


How to view existing indexes on an given table using sys.indexes?

817


What are the types of table?

748