|
|
Archives of the TeradataForum
Message Posted: Thu, 29 Nov 2001 @ 15:09:32 GMT
Subj: | | Re: Source for DDL in SHOW TABLE |
|
From: | | Dara Tressler |
The information from the Show Table command most likely came from view in DBC like Databases, Columns, Tables, Indices
A description of DBC.Tables for example - Each row of the DBC.Tables view provides information about a table, view, stored procedure or
macro. The column names are: DatabaseName, TableName, TableKind, CreatorName, ProtectionType, RequestText, and CommentString.
With these views you can format reports to taste.
Dara Tressler
Speedway SuperAmerica LLC
| |