VIEW: CN.CN_OBJECTS_ALL#

Source

View Text - Preformatted

select OBJECT_ID OBJECT_ID, DEPENDENCY_MAP_COMPLETE DEPENDENCY_MAP_COMPLETE, NAME NAME, OBJECT_TYPE OBJECT_TYPE, REPOSITORY_ID REPOSITORY_ID, OBJECT_STATUS OBJECT_STATUS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DESCRIPTION DESCRIPTION, NEXT_SYNCHRONIZATION_DATE NEXT_SYNCHRONIZATION_DATE, SYNCHRONIZATION_FREQUENCY SYNCHRONIZATION_FREQUENCY, DATA_LENGTH DATA_LENGTH, DATA_TYPE DATA_TYPE, NULLABLE NULLABLE, PRIMARY_KEY PRIMARY_KEY, POSITION POSITION, DIMENSION_ID DIMENSION_ID, DATA_SCALE DATA_SCALE, COLUMN_TYPE COLUMN_TYPE, TABLE_ID TABLE_ID, UNIQUE_FLAG UNIQUE_FLAG, PACKAGE_TYPE PACKAGE_TYPE, PACKAGE_SPECIFICATION_ID PACKAGE_SPECIFICATION_ID, PARAMETER_LIST PARAMETER_LIST, RETURN_TYPE RETURN_TYPE, PROCEDURE_TYPE PROCEDURE_TYPE, PACKAGE_ID PACKAGE_ID, START_VALUE START_VALUE, INCREMENT_VALUE INCREMENT_VALUE, ALIAS ALIAS, TABLE_LEVEL TABLE_LEVEL, TABLE_TYPE TABLE_TYPE, WHEN_CLAUSE WHEN_CLAUSE, TRIGGERING_EVENT TRIGGERING_EVENT, EVENT_ID EVENT_ID, PUBLIC_FLAG PUBLIC_FLAG, CHILD_FLAG CHILD_FLAG, FOR_EACH_ROW FOR_EACH_ROW, TRIGGER_TYPE TRIGGER_TYPE, USER_COLUMN_NAME USER_COLUMN_NAME, SEED_OBJECT_ID SEED_OBJECT_ID, PRIMARY_KEY_COLUMN_ID PRIMARY_KEY_COLUMN_ID, USER_NAME_COLUMN_ID USER_NAME_COLUMN_ID, CONNECT_TO_USERNAME CONNECT_TO_USERNAME, CONNECT_TO_PASSWORD CONNECT_TO_PASSWORD, CONNECT_TO_HOST CONNECT_TO_HOST, USER_NAME USER_NAME, SCHEMA SCHEMA, FOREIGN_KEY FOREIGN_KEY, CLASSIFICATION_COLUMN CLASSIFICATION_COLUMN, CALC_FORMULA_FLAG CALC_FORMULA_FLAG, ORG_ID ORG_ID, CALC_ELIGIBLE_FLAG CALC_ELIGIBLE_FLAG, COLUMN_DATATYPE COLUMN_DATATYPE, VALUE_SET_ID VALUE_SET_ID, OBJECT_VALUE OBJECT_VALUE, CUSTOM_CALL CUSTOM_CALL, SECURITY_GROUP_ID SECURITY_GROUP_ID, STATEMENT_TEXT STATEMENT_TEXT, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DISPLAY_COLUMN DISPLAY_COLUMN, ZD_EDITION_NAME ZD_EDITION_NAME from "CN"."CN_OBJECTS_ALL"

View Text - HTML Formatted

SELECT OBJECT_ID OBJECT_ID
, DEPENDENCY_MAP_COMPLETE DEPENDENCY_MAP_COMPLETE
, NAME NAME
, OBJECT_TYPE OBJECT_TYPE
, REPOSITORY_ID REPOSITORY_ID
, OBJECT_STATUS OBJECT_STATUS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DESCRIPTION DESCRIPTION
, NEXT_SYNCHRONIZATION_DATE NEXT_SYNCHRONIZATION_DATE
, SYNCHRONIZATION_FREQUENCY SYNCHRONIZATION_FREQUENCY
, DATA_LENGTH DATA_LENGTH
, DATA_TYPE DATA_TYPE
, NULLABLE NULLABLE
, PRIMARY_KEY PRIMARY_KEY
, POSITION POSITION
, DIMENSION_ID DIMENSION_ID
, DATA_SCALE DATA_SCALE
, COLUMN_TYPE COLUMN_TYPE
, TABLE_ID TABLE_ID
, UNIQUE_FLAG UNIQUE_FLAG
, PACKAGE_TYPE PACKAGE_TYPE
, PACKAGE_SPECIFICATION_ID PACKAGE_SPECIFICATION_ID
, PARAMETER_LIST PARAMETER_LIST
, RETURN_TYPE RETURN_TYPE
, PROCEDURE_TYPE PROCEDURE_TYPE
, PACKAGE_ID PACKAGE_ID
, START_VALUE START_VALUE
, INCREMENT_VALUE INCREMENT_VALUE
, ALIAS ALIAS
, TABLE_LEVEL TABLE_LEVEL
, TABLE_TYPE TABLE_TYPE
, WHEN_CLAUSE WHEN_CLAUSE
, TRIGGERING_EVENT TRIGGERING_EVENT
, EVENT_ID EVENT_ID
, PUBLIC_FLAG PUBLIC_FLAG
, CHILD_FLAG CHILD_FLAG
, FOR_EACH_ROW FOR_EACH_ROW
, TRIGGER_TYPE TRIGGER_TYPE
, USER_COLUMN_NAME USER_COLUMN_NAME
, SEED_OBJECT_ID SEED_OBJECT_ID
, PRIMARY_KEY_COLUMN_ID PRIMARY_KEY_COLUMN_ID
, USER_NAME_COLUMN_ID USER_NAME_COLUMN_ID
, CONNECT_TO_USERNAME CONNECT_TO_USERNAME
, CONNECT_TO_PASSWORD CONNECT_TO_PASSWORD
, CONNECT_TO_HOST CONNECT_TO_HOST
, USER_NAME USER_NAME
, SCHEMA SCHEMA
, FOREIGN_KEY FOREIGN_KEY
, CLASSIFICATION_COLUMN CLASSIFICATION_COLUMN
, CALC_FORMULA_FLAG CALC_FORMULA_FLAG
, ORG_ID ORG_ID
, CALC_ELIGIBLE_FLAG CALC_ELIGIBLE_FLAG
, COLUMN_DATATYPE COLUMN_DATATYPE
, VALUE_SET_ID VALUE_SET_ID
, OBJECT_VALUE OBJECT_VALUE
, CUSTOM_CALL CUSTOM_CALL
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, STATEMENT_TEXT STATEMENT_TEXT
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DISPLAY_COLUMN DISPLAY_COLUMN
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "CN"."CN_OBJECTS_ALL"