Constraints are the way by Databse managing the data inegrity. Types of

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

Question Posted / lekhraj

38 Answers
88264 Views
HCL, IBM, NIIT, Wipro, I also Faced
E-Mail Answers

Answer Posted / lekhraj

Constraints are the way by Databse managing the data inegrity.

Types of constraint are:-
1)NOT Null
2)Default
3)Check
4)Rule
5)Primary
6)Unique
7)Foreign

Is This Answer Correct ?

46 Yes

65 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between join and inner join?

952

Tell me what do we need queues in sql service broker?

925

How to verify a login name with sqlcmd tool?

1136

How do I schedule a sql server profiler trace?

912

Can we call future method from queueable?

993

Explain the relational database management system (rdbms)?

1018

Explain full-text query in sql server?

950

What is difference between cte and view?

854

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

990

What is an indexing strategy?

942

What is a data collection table?

943

what is the difference between Tabular and Matrix report?

160

What are synonyms?

913

What are data resources?

852

Which is the main third-party tool used in sql server?

882