Archives of the TeradataForum
Message Posted: Wed, 03 Aug 2005 @ 10:55:29 GMT
Subj: | | Re: Correlating Multiple Views and Join Views to Base Tables |
|
From: | | Coffing Christopher L |
Andrew Wrote
| "This may be of some use, courtesy of a colleague." | |
"show sel * from databasename.viewname"
If you want the fully qualified results you can use the following SQL.
show Qualified sel * from databasename.viewname
Chris Coffing
Air Force Knowledge Services (AFKS)
Lead Operations & Support
Lead Teradata DBA
Teradata NCR Contractor
Teradata Certified Master
|