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

Answer Posted / srinivas

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 ?    28 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of columns types constraints in the sql server?

799


What is the name of reporting services config file and what’s it’s used for?

121


Can we add an identity column to decimal datatype?

794


What is sql server profiler?

787


What is user defined stored procedures?

746


What is a heap?

818


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1765


What is xdr?

791


What is exclusive locks?

749


What according to you is the difference between mysql and sql server performance?

816


How to create a simple user defined function in ms sql server?

790


What is the use of stored procedure?

718


Explain the ways to controlling cursor behavior?

735


Explain in details security in SQL azure?

117


How do I connect to sql server database?

733