sql to list all teradata tables and/or views to a new table

How to list teradata views and/or tables on a new temporary table (can be a volatile table) in one column
I need the sql to do so.
So, i need a new temporary table with one column lists all the tables/views within a specific schema.
Not part of the question: after the temp table is built, i will then pull it to the unix server for my sas analysis.
Who is Participating?
rogercruseConnect With a Mentor Commented:
Select tablename from dbc.tables where databasename = 'xxxxx'

NB xxxxx is the name of your "schema"

use database name
select * from sysobjects
where xtype = 'U' OR xtype = 'V'
esna01Author Commented:
Thank you rogercruse
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.