Tags reporting tables (IBM Knowledge Catalog)

Check the Postgres, Db2 , and Oracle statements for the tables that are related to tags.

Subject area	Table name	Description
Tags	Tags	The tags that are defined.

Tags table

This table has the following columns:

tag_name - The name of the tag.

Postgres

CREATE TABLE statement:

create table tags(tag_name varchar(256) not null,
tech_start TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
tech_end TIMESTAMP(6) not null default to_timestamp('9999-12-30', 'YYYY-MM-DD'),
ts_id TIMESTAMP(6) not null default CURRENT_TIMESTAMP,
primary key(tag_name));

Db2

CREATE TABLE statement:

create table tags(tag_name varchar(256) not null,
tech_start TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row begin,
tech_end TIMESTAMP(12) not null IMPLICITLY HIDDEN generated always as row
end,
ts_id TIMESTAMP(12) not null generated always as transaction start ID,
primary key(tag_name),
period SYSTEM_TIME (tech_start,
tech_end) )

Oracle

CREATE TABLE statement:

CREATE TABLE tags(tag_name varchar(256) NOT NULL,
tech_start TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
tech_end TIMESTAMP(6) DEFAULT to_timestamp('9999-12-30', 'YYYY-MM-DD') NOT NULL,
ts_id TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
PRIMARY KEY(tag_name))

Learn more

Parent topic: Reporting tables