Overview

This is a query required when creating user table and column definitions.

Table definition

The table owner, table name, number of records, table creation date, and last DDL execution date information can be checked.

The number of records can be checked from Altibase 6.3.1, which added the performance view related to statistical information.

There are differences in the query statement for each version, so refer to the statement for each version.

Column definition

The column name, data type, size, NOT NULL, constraint information, and column order information can be checked.

There are differences in the query statement for each version, so refer to the statement for each version.