Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are various constraints used in SQL?

Answer Posted / rajshri.20

SQL constraints are used to specify rules for the data in a table.

NOT NULL - Indicates that a column cannot store NULL value
UNIQUE - Ensures that each row for a column must have a unique value
PRIMARY KEY - A combination of a NOT NULL and UNIQUE. Ensures that a column (or combination of two or more columns) have an unique identity which helps to find a particular record in a table more easily and quickly
FOREIGN KEY - Ensure the referential integrity of the data in one table to match values in another table
CHECK - Ensures that the value in a column meets a specific condition
DEFAULT - Specifies a default value when specified none for this column

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2308


Explain the difference between sql and oracle?

1077


Does oracle partitioning improve performance?

992


How to synchronize 2 schema's objects?

2181


How to use "if" statements on multiple conditions?

1174


What are the differences between number and binary_float in oracle?

1100


What do you understand by a database object?

1062


what is port in oracle? how is it related to database application.

1949


what's query optimization and without use of IN AND Exist can we get another way data from query

2141


How to create a stored program unit?

1228


What is a system tablespace?

1072


Explain the difference between a procedure and a function?

1169


What is a parameter file in oracle?

1134


What is the use of oracle?

1030


How to create a testing table in oracle?

989