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

Answer Posted / ns

constraints are like an a right or any event which can we
apply on our table or column, or its an rule of integrity
there is an types of constraint:-
1.primary key
2.foreign key
3.unique
4.check
5.default
6.not null

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

721


What is meant by Active-Passive and Active-Active clustering setup?

756


Explain rdbms?

757


What is key set driven?

709


What do you need to connect php to sql server?

767


What is normalization? What number of normalization shapes are there?

804


Why I can not enter 0.001 second in date and time literals in ms sql server?

758


What are different types of join?

958


What are the commands used in DCL?

721


What is Transparent Data Encryption?

745


Please explain what is “asynchronous” communication in sql server service broker?

704


How to generate create function script on an existing function?

790


Do comments need to go in a special place in sql server 2005?

656


How to change the name of a database user?

739


Define model database?

743