Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 88286 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 the query and subquery?
How do I run a trace in sql server?
How to connect ms access to sql servers through odbc?
What is the difference between writing data to mirrored drives versus raid5 drives
what are database files and filegroups? : Sql server database administration
How to write an inner join with the where clause in ms sql server?
Explain the commands in sql server?
What is sqlcmd?
What is a partitioned view?
What is thr feature of change data capture?
What is difference between after and before?
What is snapshot replication?
Differentiate between a primary key and a unique key.
Can we create clustered index on composite key?
What command is used to create a database in the sql server and how?
