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.
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.
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.
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.
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.