How to get table details in db2

Command line processor DESCRIBE TABLE command

The schema of the table, view, or alias. If the procedure has one or more parameters of an array type, the output from the DESCRIBE command has one additional column, that indicates the maximum cardinality of array parameters. Article available also for: Post as a guest Name. The value indicates whether the table has multilevel security: Peter Miehle Peter Miehle 5,278 2 29 51. If implicit connect is enabled, a connection to the default database is established.

Indexes List table indexes.

how to get table details in db2

The value in this field is not a reliable indicator of release dependencies. To filter results down even further, you may also wish to look for tables with a wildcard search of a few characters in the table name.

Get table info in DB2 IBM Database

It says- Error: If the table is an archive table, this column contains the schema name of the archive-enabled table. This was the only method I found that gave me that. First name. Index schema Index name Unique rule Number of columns Index type. The log RBA when the table was created. Number of pages that are used by the table. Internal identifier of the database; 0 if the row describes a view, alias, or created temporary table.

How to List Tables in IBM DB2

Schema statistics Find number of tables in database Find number of columns in database List of tables with the most columns Average number of columns per table. Total number of rows in the table or total number of LOBs in an auxiliary table.

A value of 'FFFFFF00' in this column indicates that the edit procedure on this table is defined without row attribute sensitivity. The row describes a view, an alias, a created temporary table, or a materialized query table. New Learning Platform We've launched a new website to help you understand the data principles you need to get answers today. Select the required table and extract expand it. Expressions in square brackets following the generated column name for any part of an index key that is based on an expression.

how to get table details in db2

Control Center already got the feature of that. If the table is an archive table, this column contains the table name of the archive-enabled table. Internal identifier of the table; 0 if the row describes a view, an alias, or a created temporary table.

how to get table details in db2