What are constraints? Explain different types of
constraints?

Answer Posted / md. aftab alam

It is a part of the table definition that are used to limit the values entered into its columns.its type are
1. Not null
2. Unique
3. primary key
4. Ckeck
5. Reference key

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me about joins in database system and explain each in detail.

602


Explain nested stored procedure. Syntax and an example for create nested stored procedure?

535


What happens if null values are involved in arithmetic operations?

592


What is database architecture? : SQL Server Architecture

555


Give an example of why you would want to denormalize a database

520






What is acid mean in sql server?

580


How to execute the cursor queries with "open" statements?

618


You want to implement the many-to-many relationship while designing tables. How would you do it?

568


What are the two modes of authentication in sql server?

526


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

546


What are the different sql server versions?

523


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

551


How to remove duplicate rows from table except one?

576


Do you know what are the differences between lost updates and uncommitted dependencies?

547


What stored by the master?

549