Which catalog table stores referential constraints ?


The SYSIBM.SYSRELS table.

DB2 Directory



Explore posts in the same categories: Database Interview Questions


BOOKMARK THIS : del.icio.us | Digg it | Furl | reddit |


Related Questions :

  • What is the difference between Truncate and Delete interms of Referential Integrity?
  • DELETE removes one or more records in a table, checking referential Constraints (to see if there are dependent child records) and...
  • What information can you find in SYSIBM.SYSLINKS table ?
  • The SYSIBM.SYSLINKS table contains information about the links between tables created by referential constraints....
  • What are triggers? How to invoke a trigger on demand?
  • Triggers are special kind of stored procedures that get executed automatically when an INSERT, UPDATE or DELETE operation takes place...
  • What is a mutating and constraining table?
  • "Mutating" means "changing". A mutating table is a table that is currently being modified by an update, delete, or insert...
  • Where besides the DB2 catalog is database object information stored by DB2 ?
  • DB2 also stores information about DB2 objects as database descriptors (DBDs) in the DBD Directory table....
  • What does the RUNSTATS Utility do?
  • The RUNSTATS Utility collects statistical information for DB2 table spaces, partitions, indexes, tables and columns and stores this data in...
  • Give two examples of referential integrity constraints?
  • A primary key and a foreign key. ...
  • What is the use of CONSTRAINTS option in EXP command ?
  • A flag to indicate whether constraints on table need to be exported....
  • Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database ?
  • The catalog tables to use are the SYSIBM.SYSTABLES and the SYSIBM.SYSCOLUMNS....
  • How will you activate/deactivate integrity constraints?
  • The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT....

    Comments are closed.