Interested to Buy Any Domain ? << Click Here >> for more details...
What are various constraints used in SQL?
- 1 Answers
- 3931 Views
- Polaris, I also Faced
- E-Mail Answers
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 |
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to run the anonymous block again?
What are the predefined tablespaces in a database?
What is primefaces used for?
what is the difference between UNION AND UNIONALL
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
What privilege is needed for a user to create tables in oracle?
what is primary key and foreign key when and where have to use
I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Explain a segment?
What a SELECT FOR UPDATE cursor represent.?
Oracle General 
