What is a constraint. Types of constraints ?
Answer Posted / sujit.1551
constraint are nothing but a conditions,in other words
enforcing the business rules into the database.
types of constraits:
1)check constraint
2)unique constraint
3)primary key
4)foreign key
5)Not null
6)Default
| Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
what is data integrity? : Sql dba
Is it important to partition hard disk?
what is a stored procedure? : Sql dba
How to order siblings in oracle hierarchy queries?
Can we join more than 2 tables in sql?
Can we create clustered index without primary key?
Do we need to create index on primary key?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Which tcp/ip port does sql server run?
how to rename an existing column in a table? : Sql dba
What are pl/sql cursors?
Is sql similar to python?
What is the starting oracle error number?
What is the purpose of a secondary key?
Why is %isopen always false for an implicit cursor?