What are constraints? Explain different types of
constraints?

Answer Posted / satyanarayana

Constraints are the constraints which can provide on the
column data.The types of constraints are
1).Domain Integrity constraints
EX:Check
2).Entity Integrity constraints
Ex:Unique,Primary key
3).Referential Integrity constraints
EX:Foreignkey

Is This Answer Correct ?    136 Yes 41 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new security features added in sql server 2012? : sql server security

532


What is the synonym of join?

517


How data can be copied from one table to another table?

507


What are the elements of dbms?

541


if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

524






What are the basic functions for master, msdb, model, tempdb and resource databases?

548


How to create a ddl trigger using "create trigger" statements?

610


What is the difference between mysql and sql server?

467


What is a Join and explain its types?

581


What do we need queues in sql service broker?

522


What is shrink log file?

512


How to get a list of columns in a view using the "sp_columns" stored procedure?

612


How to drop an existing table?

545


What is the difference between a function and a trigger?

571


What are the differences between substr and charindex in sql server.

495