All Forums Database
cloghin 17 posts Joined 04/12
06 Nov 2012
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

Qaisar Kiani 337 posts Joined 11/05
06 Nov 2012

Try SHOW SEL * FROM DBC.COLUMNS

Fred 1096 posts Joined 08/04
06 Nov 2012

Try SHOW QUALIFIED SELECT * FROM db.viewname;

You must sign in to leave a comment.