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

Answer Posted / shankar k

Constraint are used to table columns validations.
there are some constraints.

Primary key,
Foreign Key,
Not Null,
Check,
Unique Key,
default

Is This Answer Correct ?    43 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is report rendering ?

131


What are the operating modes in which database mirroring runs?

816


Write a SQL query to make a column as unique?

779


What are different type of Collation Sensitivity?

743


What is the difference RDBMS and Graph Database?

804






What is format parameter in ssrs?

128


How to use subqueries with the exists operators in ms sql server?

798


What are partitioned views and distributed partitioned views?

798


What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

781


Can we take the full database backup in log shipping?

719


How you would rewrite the sql query to return the customerid sorted numerically?

758


What's the information that can be stored inside a bit column?

709


how many bits ip address consist of? : Sql server database administration

634


How can you append an identity column to a temporary table?

624


What are the restraints imposed on the table design by a merge replication?

791