Interested to Buy Any Domain ? << Click Here >> for more details...
What are various constraints used in SQL?
- 1 Answers
- 3859 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 |
How to view existing locks on the database?
Hi Can any one tell me what are the API's used in requisition import.
How do I connect to oracle?
Explain what are the advantages of views?
why pl sql doesn't support retrieving multiple records
How to change system global area (sga) in oracle?
How to use like conditions in oracle?
what is normalisation?what are its uses?
How to assign values to data fields in record variables?
what is primary key and foreign key when and where have to use
Explain the importance of .pll extension in oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Oracle General 
