Useful system views

Database
Enthusiast

Useful system views

Hi all,

I'm new to Teradata and trying to learn my way around. I started out by trying to expand all the views in my test database, but the list is so long the expansion takes forever. So, now I'm trying to find a system view from which I can query just view names. I hit DBC.Tables, but that only has actual tables -- where did they hide the views?

Thanks,
David
3 REPLIES
Junior Contributor

Re: Useful system views

Hi David,
dbc.tables has just the wrong name, you'll find tables, views, procedures. triggers, just everything in it.

Check the Data Dictionary manual for a description of all the dbc views.

Dieter
Enthusiast

Re: Useful system views

Got it, thanks!
Enthusiast

Re: Useful system views

Restrict it using Tablekind='V' and you can restrict it using databasename=(Whatever you want say DBC etc etc..

Rgds,
Raja