All Forums Database
mike_nguyen 5 posts Joined 03/06
04 Apr 2006
How to get tablename

Hi,What is the equivalent for select table_name from user_tables in Teradata database?Thanks,Michael

Jeanne-Anne 5 posts Joined 09/05
04 Apr 2006

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

mike_nguyen 5 posts Joined 03/06
04 Apr 2006

I found it:select tablename from dbc.tables where database=your databaseThanks,Michael

young 14 posts Joined 03/06
20 Apr 2006

help database dbname;you can get all tablename within your dbname

You must sign in to leave a comment.