How to get tablename

Database
Enthusiast

How to get tablename

Hi,

What is the equivalent for

select table_name from user_tables in Teradata database?

Thanks,

Michael

3 REPLIES
Enthusiast

Re: How to get tablename

What sort of equivalent? What are you trying to do?
Enthusiast

Re: How to get tablename

I found it:

select tablename from dbc.tables where database=your database

Thanks,

Michael

Enthusiast

Re: How to get tablename

help database dbname;

you can get all tablename within your dbname