Nickname: USER.NICK_REFERENTIAL_CONSTRAINTS

Properties

Name: NICK_REFERENTIAL_CONSTRAINTS 
Schema: USER 
Wrapper: CONNECT 
Remote server: TEST 
Remote schema: SYSIBM 
Remote table: REFERENTIAL_CONSTRAINTS 
Readonly:  
Cached:  
Materialised view:  
Status: NORMAL 
Create time: 01.07.2006 
Description:  

Columns

Name Type Length Scale Codepage Identity Nulls Default Description
  CONSTRAINT_CATALOG  VARCHAR  128  0  1251         
  CONSTRAINT_SCHEMA  VARCHAR  128  0  1251         
  CONSTRAINT_NAME  VARCHAR  128  0  1251         
  UNIQUE_CONSTRAINT_CATALOG  VARCHAR  128  0  1251         
  UNIQUE_CONSTRAINT_SCHEMA  VARCHAR  128  0  1251         
  UNIQUE_CONSTRAINT_NAME  VARCHAR  128  0  1251         
  MATCH_OPTION  VARCHAR  4  0  1251         
  UPDATE_RULE  VARCHAR  9  0  1251         
  DELETE_RULE  VARCHAR  9  0  1251         
Total: 9 column(s)

Autherisations

Grantor Grantee Authorities
  SYSIBM  USER  CONTROL=HELD, ALTER=HELD_GRANTABLE, DELETE=HELD_GRANTABLE, INDEX=HELD_GRANTABLE, INSERT=HELD_GRANTABLE, SELECT=HELD_GRANTABLE, REFERENCE=HELD_GRANTABLE, UPDATE=HELD_GRANTABLE 
Total: 1 autherisation(s)

See Also

List of nicknames