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

Answer Posted / mudit

Constraint are the rules enforced on data columns on table.

Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check

Is This Answer Correct ?    338 Yes 56 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

why would you call update statistics? : Sql server database administration

570


How to automatically create a log when an exception is being received into SQL Server?

733


What happens if null values are involved in boolean operations?

553


Where do we use trace frag?

568


Explain transaction server explicit transaction?

502






What are the types of database schema? : sql server analysis services, ssas

598


What is join query?

496


How do I setup a local sql server database?

535


What is code near application topology?

197


What is full outer join in sql server joins?

565


What does it mean to invest in the index?

505


Explain DBCC?

566


How to count rows with the count(*) function in ms sql server?

534


What is difference between equi join and inner join?

482


Define views.

588