show view does not show databasename in viewname

Database
Enthusiast

show view does not show databasename in viewname

I am trying to export all objects from certain databases . I noticed in some cases the show view output does not contain a databasename, probably using the default database. Is it possible to force the show view output to be more specific so that DDL can be modified and executed without relying on a default db ?

Example

show view db.viewname

CREATE VIEW viewname AS LOCKING TABLE .....

Thanks.

Colin

2 REPLIES
Enthusiast

Re: show view does not show databasename in viewname

Try SHOW SEL * FROM DBC.COLUMNS

Teradata Employee

Re: show view does not show databasename in viewname

Try SHOW QUALIFIED SELECT * FROM db.viewname;