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

Answer Posted / seshu

constraint is a mechanism it is used to prevent the invalid
data entry in to the table is called constraint.
constraints are 5 types they are,

1 Primary Key Constraint
2 Foreign Key Constraint
3 Unique Constraint
4 Not Null Constraint
5 Check Constraint

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What will be the maximum number of indexes per table?

537


What gets stored inside msdb database?

769


Can sql server 2016 run on windows 7?

507


How you can change a cross join into an inner join?

555


Which database stores information about replication?

559






State a few properties of relational databases?

665


What are the disadvantages of using querystrings to send data from one page to another?

588


What is the difference between online clustering and Offline clustering?

1922


What is difference between unique and primary key?

480


What are constraints?

592


What are the five major components of a dbms?

514


Can sql servers linked to other servers?

550


Can we do dml on views?

555


Explain different types of self contained sub query?

546


What is explicit mode in sql server?

536