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';
SELECT * FROM DBC.TABLES WHERE TABLEKIND='V' AND DATABASENAME='TEST';
No comments:
Post a Comment