what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 80063 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
Which command is used for user defined error messages?
What happens to a trigger with multiple affected rows?
Explain what are the events recorded in a transaction log?
Can you name a few encryption mechanisms in sql server?
What is a benefit of using an after insert trigger over using a before insert trigger?
How to include date and time values in sql statements?
What is catalog views?
What is clustered vs nonclustered index?
What is default constraint in ms sql server?
Explain about system stored procedure?
Explain the third normal form(3nf)?
How to write character string constants or literals in ms sql server?
How to create sub reports?
How to connect of datebase with sql express.?
Explain primary key and foreign key constraints?
