Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 90888 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
What is transaction server explicit transaction?
How do you open a cluster administrator?
what are the critical issues you have resloved in your company
How can a user-defined datatype be created?
How to write a query with an inner join in ms sql server?
What are various limitations of the views?
What is scheduled job and how to create it?
What is data file in computer?
How do I partition a table in sql server?
What are the different subsets of sql?
Where in ms sql server is ’100’ equal to ‘0’?
Can we use where clause with group by?
What are sql server procedures?
Where views are stored in sql server?
Why would you call update statistics?
