Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Friday 24 July 2015

How to fetch all the views from particuler Teradata database

You can fetch all the views from Teradata Database with the help of DBC.TABLES views by executing below query:-

SELECT * FROM DBC.TABLES WHERE TABLEKIND='V' AND DATABASENAME='TEST';

No comments:

Post a Comment

Please provide your feedback in the comments section above. Please don't forget to follow.