|
|
Archives of the TeradataForum
Message Posted: Mon, 13 Dec 2004 @ 12:26:21 GMT
Subj: | | Re: Finding View information |
|
From: | | Sanchez, Kiki |
| Could someone tell me how can I get all information about a view. Like, View ColumnName , base tablename , base columnname , base column
datatype...... Etc... | |
I know that "help column database.viewname.*" will give you the column information that you are asking for. I am not aware how to get the base
tablename itself without actually parsing thru the view text.
Kiki Sanchez
Data Warehouse Group
Technology Division
Continental Airlines
| |