sp_tables

sp_tables 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]

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 for 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 specified type:
```
"'TABLE', 'SYSTEM TABLE', 'VIEW'"
```
Note: Enclose each table type with single quotation marks, and enclose the entire parameter in double quotation marks. Enter table types in uppercase.

Example 1 – returns information about all tables of the type TABLE and VIEW and excludes information about system tables:
```
DCSERVER...sp_tables @table_type = "'TABLE', 'VIEW'"
```

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.

Any user can execute sp_tables.