• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 15748
  • Last Modified:

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.
0
esna01
Asked:
esna01
1 Solution
 
adraughnCommented:
try:

use database name
select * from sysobjects
where xtype = 'U' OR xtype = 'V'
0
 
rogercruseCommented:
Select tablename from dbc.tables where databasename = 'xxxxx'

NB xxxxx is the name of your "schema"
0
 
esna01Author Commented:
Thank you rogercruse
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now