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