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

Member

by dedrick , in category: MySQL , 6 months ago

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

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by edmond_brakus , 6 months 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.

Related Threads:

How to see webpack warnings?
How to see customers of woocommerce?
How to check to see if a reaction is posted in discord.js?
How to use helpers in CakePHP views?
How to use partial views in prism?
How to change the views in prism?