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

What is the fillfactor concept in indexes?

532


How to transfer a table from one schema to another?

560


What command do we use to rename a database?

618


Explain about analysis services?

579


How to convert character strings into numeric values?

579






Is sql server implemented as a service or an application? : Sql server database administration

512


What is database mirroring?

567


Which tcp/ip port does sql server run on? How can it be changed?

575


Mention the different authentication modes in sql server.

536


How to perform key word search in tables?

534


What is a user-defined function in the sql server and what is its advantage?

619


What do you mean by data integrity?

599


What is dbcc updateusage?

536


Explain the difference between function and stored procedure?

517


What is reportserver and reportservertempdb ?

107