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

Answer Posted / raghunath k

Constraints are some rules that are inforced on the data object.
there are five types of costriants in SQL, they are
1. NOT NULL CONSTRAINTS.
2. UNIQUE CONSTRAINTS.
3. PRIMARY KEY CONSTRAINTS.
4. FOREIGN KEY CONSTRAINTS.
5. CHECK CONSTRAINTS.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Characterize join and name diverse sorts of joins?

682


What is difference between Datepart() and Datename() in SqlServer?

904


Can you edit the .rdl code associated with a linked report?

121


What is compression - row-level and page-level compression?

687


What are different types of schemas?

690






How many types of attribute relationships are there? : sql server analysis services, ssas

776


When multiple after triggers are attached to sql table, how to control the order of execution?

739


How sql server enhances scalability of the database system?

780


What is sql server programming?

761


Can you name some of the dml commands in sql?

756


Can we deploy SSRS reports on our personal website?

148


How to convert numeric expression data types by assignment operations?

726


what is the information that can be stored inside a bit column? : Sql server database administration

707


What is table-valued sub query?

736


Explain the commands in sql server?

732