[DB] Informix SystemTable 應用

Informix 中，可以用下列的指令取得Table Name,

select tabname from systables
where tabname your condition

Table 1. SYSTABLES table column descriptions

Column	Type	Explanation
tabname	VARCHAR(128)	Name of table, view, synonym, or sequence
owner	CHAR(32)	Owner of table (user informix for system catalog tables and usernamefor database tables)
partnum	INTEGER	Physical storage location code
tabid	SERIAL	System-assigned sequential identifying number
rowsize	SMALLINT	Maximum row size in bytes ( < 32,768)
ncols	SMALLINT	Number of columns in the table
nindexes	SMALLINT	Number of indexes on the table
nrows	FLOAT	Number of rows in the table
created	DATE	Date when table was created or last modified
version	INTEGER	Number that changes when table is altered
tabtype	CHAR(1)	Code indicating the type of table object: T = Table E = External Table V = View Q = Sequence P = Private synonym S = Public synonym (Type S is unavailable in an ANSI-compliant database.)
locklevel	CHAR(1)	Lock mode for the table: B = Page and row level P = Page level R = Row level
npused	FLOAT	Number of data pages that have ever been initialized in the tablespace by the database server
fextsize	INTEGER	Size of initial extent (in KB)
nextsize	INTEGER	Size of all subsequent extents (in KB)
flags	SMALLINT	Codes for classifying permanent tables: ROWID 1 - Has rowid column defined UNDER 2 - Table created under a supertable VIEWREMOTE 4 - View is based on a remote table CDR 8 - Has CDRCOLS defined RAW 16 - (Informix) RAW table EXTERNAL 32- External table AUDIT 64 - Audit table attribute - FGA AQT 128 - View is an AQT for DWA offloading VIRTAQT 256 - View is a virtual AQT
site	VARCHAR(128)	Reserved for future use
dbname	VARCHAR(128)	Reserved for future use
type_xid	INTEGER	Code from sysxtdtypes.extended_idfor typed tables, or 0 for untyped tables
am_id	INTEGER	Access method code (key to sysamstable) NULL or 0 indicates built-in storage manager
pagesize	INTEGER	The pagesize, in bytes, of the dbspace (or dbspaces, if the table is fragmented) where the table data resides.
ustlowts	DATETIME YEAR TO FRACTION (5)	When table, row, and page-count statistics were last recorded
secpolicyid	INTEGER	ID of the SECURITY policy attached to the table. NULL for non-protected tables
protgranularity	CHAR(1)	LBAC granularity level: R: Row level granularity C: Column level granularity B: Both column and row granularity Blank for non-protected tables
statlevel	CHAR(1)	Statistics level T = table F = fragment A = automatic
statchange	SMALLINT	For internal use only