How to see all the views under a schema in teradata?

@dedrick 

To see all the views under a schema in Teradata, you can use the following SQL query:

1
2
3
4

SELECT * 
FROM DBC.TABLES
WHERE TABLEKIND = 'V'
AND DATABASENAME = '<schema_name>';

Replace <schema_name> with the name of the schema you want to view the views for. This query will retrieve all views under the specified schema in Teradata.