query to see all db tables in Teradata

This forum is for Database developer ( PostgreSQL, MySQL, SQL Server, Oracle etc...) and database Administrator
user123
Posts: 91
Joined: Sun Aug 30, 2015 7:57 am
Contact:

query to see all db tables in Teradata

Postby user123 » Mon Oct 12, 2015 8:43 pm

i am looking for query to see all db tables in Teradata.

How to get all the tables for the specific database in Teradata?


Guest

Re: query to see all db tables in Teradata

Postby Guest » Mon Oct 12, 2015 8:51 pm

use below query to select the all tables.

SELECT TABLENAME FROM DBC.TABLES WHERE DATABASENAME = 'DBNAME'


Return to “PostgreSQL, MySQL, SQL Server, SQL,PL/SQL, TeraData Developer and DataBase Administration”

Who is online

Users browsing this forum: No registered users and 1 guest