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

Member

by dedrick , in category: MySQL , 17 days ago

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

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by edmond_brakus , 16 days ago

@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.