Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 89460 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
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
How do indexes help, types?
What is rank function?
Explain primary key, foreign key and unique key?
What is difference between getdate and sysdatetime in sql server 2008?
What happens if the update subquery returns no rows in ms sql server?
What are the disadvantages of indexes?
What is the largest component inside a field?
Explain indexed views?
Describe in brief authentication modes in sql server.
Explain the use of keyword with encryption. Create a store procedure with encryption?
How to test odbc dsn connection settings?
What is the sql server agent?
Do you know what is blocking?
Does windows server 2016 come with sql server?
What is the full meaning of dml?
