ns_table

Overview

Find information about tables in the database

Syntax

ns_table bestrowid dbhandle table

ns_table exists dbhandle table

ns_table list dbhandle

ns_table listall dbhandle

ns_table value dbhandle table key

Description

ns_table bestrowid returns a list of the column names that uniquely identify a row in the specified table. The Illustra driver always returns "oid", but other databases may return the primary keys for a table.

ns_table exists returns 1 (one) if the specified table exists in the specified database and 0 (zero) if it does not. This function can be slow (up to a second).

ns_table list returns a list of all the non-system tables in the specified database, including views.

ns_table listall returns a list of all tables in the specified database, including views and system tables.

ns_table value returns table information specified with the Customize Table page in Database Services. For example, key = "description" will return the table description. This function returns extended table information and is therefore available only if the ExtendedTableInfo configuration parameter is set on for the database pool.