difference between table level constraint and column level and
advantages of table level constraint

Answer Posted / selvi

Column level constraint can not refer other columns or sysdate, UID, currVal, nextVal or rownum, and this is limitation of column level constraint over table level constraint.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the syntax for using sql_variant_property? : Transact sql

523


Why do we need cursor in pl sql?

637


Is there a 64 bit version of ssms?

504


How many rows can sqlite handle?

576


What is sqlca in powerbuilder?

554






How does a self join work?

508


How much does sqlite cost?

548


What are the types of records?

519


What is int identity in sql?

567


What is the main difference between sql and pl/sql?

557


What is dml with example?

507


Why is a primary key important?

537


what is oltp (online transaction processing)? : Sql dba

523


What is prepared statement in sql?

536


Can we update views in sql?

524