sp_tables

Description

Returns a list of objects that can appear in a from clause.

Syntax

server_name... sp_tables [table_name] [, table_owner] 
	[, table_qualifier][, table_type]

Parameters

table_name: is the name of the table. Use wildcard characters to request information about more than one table.

table_owner: is the owner of the table. Use wildcards to request information about tables that are owned by more than one user.

table_qualifier: is ignored. Use NULL.

table_type: is a list of values, separated by commas, giving information about all tables of the table type(s) specified, including the following:

"'TABLE', 'SYSTEM TABLE', 'VIEW'"

Enclose each table type with single quotation marks, and enclose the entire parameter with double quotation marks. Enter table types in uppercase.

Examples

Example 1

DCSERVER...sp_tables @table_type = "'TABLE', 'VIEW'"

This procedure returns information about all tables of the type TABLE and VIEW and excludes information about system tables.

Usage

ECDA Option for Oracle does not necessarily check the read and write permissions on table_name. Access to the table is not guaranteed, even if you can display information about it.

The results set includes tables, views, synonyms, and aliases.

Table 3-6 describes the results set:

**Table 3-6: Results set for sp_tables**
Column	Datatype	Description
table_qualifier	varchar(30)	NULL.
table_owner	varchar(30)	Table owner
table_name	varchar(30)	NOT NULL. The table name.
table_type	varchar(32)	NOT NULL. One of the following: 'TABLE', 'VIEW', 'SYSTEM TABLE'.
remarks	varchar(254)	NULL

Permissions

Any user can execute sp_tables.