What are constraints? Explain different types of
constraints?

Answer Posted / manish nagar

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

Constraints can be specified when a table is created (with
the CREATE TABLE statement) or after the table is created
(with the ALTER TABLE statement).

NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
CHECK
DEFAULT

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to generate random numbers with the rand() function in ms sql server?

561


What are the properties of the transaction?

537


What do you understand by user-defined function in the sql server?

483


What is cached report?

106


What the class forname () does?

534






What are the benefits of filtered indexes?

501


Explain what are page splits? : SQL Server Architecture

649


What is the difference between value type and reference type?

549


Explain the creation and execution of a user-defined function in the sql server?

572


Define master database?

574


what is database replication? : Sql server database administration

526


What is constraints and its types?

495


What is a deadlock and what is a live lock?

567


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

577


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

598