What are constraints? Explain different types of
constraints?

Answer Posted / ravi gupta

constraint define rules that must be followed to maintain
consistency and correctness of data.a constraint can either
be created while creating a table or can be added later.
constraint can be divided into the following types:--
(1)primary key constraint.
(2)unique constraint.
(3)foreign key constraint.
(4)check constraint.
(5)default constraint.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me what is log shipping?

560


List few advantages of stored procedure.

531


How do I start sql server 2016?

519


how can you attach more than 20 ldf files in sql server

1565


What is primary key index?

530






Can a table have 2 foreign keys?

499


What is a fan-out query in SQL Azure?

99


What are character string data types in ms sql server?

626


How to verify the port number of the sql server?

547


How do you create a data source?

464


What is sql server profiler?

564


What is the New in SQL server 2008?

572


What is an sql server agent?

541


How to include text values in sql statements?

580


What happens if null values are involved in arithmetic operations?

579