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

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

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1379


What is the largest component inside a field?

534


How to create stored procedures with parameters in ms sql server?

529


What are the steps to take to improve performance of a poor performing query? : sql server database administration

600


What do you need to connect php to sql server?

545






How to create a simple stored procedure in ms sql server?

523


on line cluster can we make if yes tell me the procedure

1517


Can we install sql server 2016 on windows 7?

677


What is msdb database? : SQL Server Architecture

541


List out what other servers you can use with ssrs?

93


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

577


How would you use user_constraints table in DB?

592


What is blocking and how would you troubleshoot it? : sql server database administration

594


How to access the deleted record of an event?

579


What are the steps to process a single select statement?

515