InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:38:11 GMT20http://www.teradata.com/teradataforum/Topic12332-9-1.aspxhi,**Robert's solution will provide you what you want.I have just split up his query since these are huge views.CREATE VOLATILE TABLE DBC_VT AS (SEL DATABASENAME FROM DBC.DATABASESWHERE DATABASENAME NOT IN ('DBC','CRASHDUMPS') AND DBKIND='U' ) WITH DATA ON COMMIT PRESERVE ROWS ;SEL A.TABLENAMEFROM DBC.COLUMNS A, DBC_VT VTWHERE A.DATABASENAME = VT.DATABASENAME AND A.COLUMNNAME = 'ACC_NO' ;HTH,Tue, 05 Aug 2008 14:59:51 GMTSNhttp://www.teradata.com/teradataforum/Topic12332-9-1.aspxwe can remove the databasename filter and keep only the columnname filter.likeSELECT TABLENAME,DATABASENAME FROM DBC.COLUMNS DBC WHERE DBC.COLUMNname = 'ABC' ;it should give all the databases on a teradata machine.Wed, 30 Jul 2008 22:54:27 GMTnovicehttp://www.teradata.com/teradataforum/Topic12332-9-1.aspxsorry .... Table Names not the column names ....ThanksWed, 30 Jul 2008 02:24:11 GMTDileep Banalahttp://www.teradata.com/teradataforum/Topic12332-9-1.aspxyes .... but am sorry that i need that query to be modifiedsuch that it results in fetching the column names from different databases ....Could you pls help me in this regard?ThanksWed, 30 Jul 2008 02:23:10 GMTDileep Banalahttp://www.teradata.com/teradataforum/Topic12332-9-1.aspxhi,I see that you already posted this query and got the response from Robert F. Brooks.Tue, 29 Jul 2008 09:45:15 GMTSNhttp://www.teradata.com/teradataforum/Topic12332-9-1.aspxHi AllSELECT DBC.TABLE_NAME FROM DBC.COLUMNS WHERE DBC.COLUMN = 'ACC_NO' AND DATABASENAME='DB1'The above query will give me the table names from a single database called DB1, but i want the table names from a dev environment which has 1300+ databases.How can i fetch all the table names with a single query in teradata?And also it should not fetch the system tables.....Can anyone help me in this regard?ThanksTue, 29 Jul 2008 08:18:45 GMTDileep Banala