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.

Top of Page
Copyright © 1996 America Online, Inc.