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

Answer Posted / scornguy

Constraints are used to limit the type of data that can go
into a table.

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

Is This Answer Correct ?    225 Yes 29 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a self join? : Sql server database administration

695


What is page-level compression?

721


What are scheduled tasks in sql server?

731


What is a fill factor?

820


Why use “in” clause in sql server?

727






What is the difference between grant and with grant while giving permissions to the user?

728


When is update_statistics command used?

773


Define msdb database?

785


What command must you use to include the not null constraint after a table has already been created?

756


What is the importance of a recovery model?

773


What is a result set object returned by mssql_query()?

737


What is the Main Difference between ACCESS and SQL SERVER?

747


What is update locks?

660


What is encryption key?

98


Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

860