Visit Teradata.com Home    Search    Guidelines    Member List

Welcome Guest ( Login | Register )       Recent Posts    Popular Topics

Teradata Discussion Forums » Teradata » Teradata Database » Teradata sql to give the table names when you...

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

Teradata sql to give the table names when you... Rate Topic Display Mode Topic Options Author Message Dileep Banala Posted 7/28/2008 2:10:12 AM Junior Member Group: Forum Members Last Login: 8/22/2008 11:30:56 AM Posts: 22, Visits: 41 Hi All Am trying to find out the Teradata sql to give the table names when you have given the column names in a database. For Example in oracle to find the table names which uses the column EXTRACT_SYS_ID. SELECT TABLE_NAME FROM all_tab_cols WHERE COLUMN_NAME ='EXTRACT_SYS_ID'; What is the sql related to Teradata. Dileep Post #12276 Adeel.Chaudhry Posted 7/28/2008 2:18:39 AM Supreme Being Group: Forum Members Last Login: Yesterday @ 7:30:07 AM Posts: 197, Visits: 611 Hello, You can use DBC.Columns table for that. Regards, Adeel Post #12277 Dileep Banala Posted 7/28/2008 5:27:11 AM Junior Member Group: Forum Members Last Login: 8/22/2008 11:30:56 AM Posts: 22, Visits: 41 Hi select * from DBC.Columns where ColumnName = 'ACC_NO' The above query results with the System tables also .... but i need only the user tables ....... Can u pls suggest me the way to do it. Thanks Dileep Dileep Post #12280 Adeel.Chaudhry Posted 7/28/2008 6:05:28 AM Supreme Being Group: Forum Members Last Login: Yesterday @ 7:30:07 AM Posts: 197, Visits: 611 Well...for that you can filter using DatabaseName... Regards, Adeel Post #12284 Dileep Banala Posted 7/28/2008 7:16:19 AM Junior Member Group: Forum Members Last Login: 8/22/2008 11:30:56 AM Posts: 22, Visits: 41 is it this way ?? select DatabaseName.Table_Name from DBC.Columns where Column_Name = 'ACC_NO' ?? Could you please give me the exact query?? Regards Dileep Post #12296 Adeel.Chaudhry Posted 7/28/2008 7:20:52 AM Supreme Being Group: Forum Members Last Login: Yesterday @ 7:30:07 AM Posts: 197, Visits: 611 Can you please define the system tables? And do you know the name of database in which you need to search for the column? Regards, Adeel Post #12298 Dileep Banala Posted 7/28/2008 7:24:45 AM Junior Member Group: Forum Members Last Login: 8/22/2008 11:30:56 AM Posts: 22, Visits: 41 yah .... say for example Database name is Account. but still i doubt whether Account.Table_Name works fine ?? Regards Dileep Post #12299 Adeel.Chaudhry Posted 7/28/2008 7:28:39 AM Supreme Being Group: Forum Members Last Login: Yesterday @ 7:30:07 AM Posts: 197, Visits: 611 You can use it as follows: SELECT * FROM DBC.Columns WHERE ColumnName = 'ACC_NO' AND DatabaseName = 'Account'; Regards, Adeel Post #12301 « Prev Topic | Next Topic »

Reading This Topic Active Users: 2 ( 2 guests, 0 members, 0 anonymous members ) No members currently viewing this topic.