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

Answer Posted / bimaleswar patel

Constraints are used to limit the type of data that can go
into a table.
two basic types of constraints are there
1.column level
2.table level
the difference is that column level constraints are apply
only to one column where as table level constraints are
apply to whole table
Constraints are declare at the time of table creation using
CREATE TABLE command

there are 6 constraints used in oracle
1.NOT NULL
2.UNIQUE
3.PRIMARY KEY
4.CHECK
5.DEFAULT
6.REFERENCES

Is This Answer Correct ?    96 Yes 24 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to insert a new row into a table with "insert into" statements in ms sql server?

770


Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

786


What is a join in sql?

800


How do you send email on SQL Server?

815


What are some examples of schemas?

764


What stored by the tempdb ? : sql server database administration

827


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2036


The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

772


How to access the inserted record of an event?

834


Explain how many types of relationship?

812


tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

792


What is BCP? When does it used in sql server 2012?

821


How do I create a stored procedure in dbml?

741


How to turn on the mssql api module in php?

823


What is partition index in sql server?

854