sp_tables

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

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

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

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.

DirectConnect 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 4-6 describes the results set:

**Table 4-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

Any user can execute sp_tables.