Interested to Buy Any Domain ? << Click Here >> for more details...
difference between table level constraint and column level and
advantages of table level constraint
- 4 Answers
- 15779 Views
- Doyensys, I also Faced
- E-Mail Answers
Answer Posted / anil
ANS:
COLUMN LEVEL CONSTRAINT
If we provide constraint along with column while creating the table then it is column level constraint. For column level constraint a constraint name is not mandatory.
TABLE(ROW) LEVEL CONSTRAINT
If we provide constraint after providing all the columns then it is table level constraint.For table level constraint a constraint name is mandatory.
Advantage of table level constraint:
We can create composite PK and composite FK in table level constraints but we cant create these in column level constraints.
Example:
CREATE TABLE oracle_tab
(
ord_id NUMBER,
pid NUMBER,
qty NUMBER(2),
ord_dt DATE NOT NULL, /*column level constraint(cant be created as table level constraint)*/
price NUMBER(9,1) DEFAULT 0, /*column level constraint(cant be created as table level constraint)*/
CONSTRAINT ord_pk PRIMARY KEY(ord_id,pid), /*table level(can be created either as table level constraint or column level)*/
CONSTRAINT ord_fk FOREIGN KEY(pid) REFERENCES products(pid),/*table level(can be created either as table level constraint or column level)*/
CONSTRAINT ord_ch CHECK(qty>0) /*table level(can be created either as table level constraint or column level)*/
);
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Why we use sql profiler?
What is a primary key? Explain
Write a sql query to get the third highest salary of an employee from employee_table?
How to create an array in pl/sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is dense_rank in sql?
What is query optimization in sql?
What is a join query?
What is dba in sql? : SQL DBA
what are null values? : Sql dba
what is denormalization. : Sql dba
What is substitution variable in pl sql?
How to revise and re-run the last sql command?
Can you upgrade sql express to full sql?
What is where clause in sql?
