InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:52:29 GMT20http://www.teradata.com/teradataforum/Topic12318-9-1.aspxdepends from which user u are executing..............might be possible u don't have access on this schema because this is sys schemadbc is default schema for Teradata....it should run....Regards,SubhashFri, 01 Aug 2008 01:38:07 GMTgander_sshttp://www.teradata.com/teradataforum/Topic12318-9-1.aspxHi subhash:I am trying to execute your querybut I am getting 3807 error sayingdatabase does not existThu, 31 Jul 2008 17:01:47 GMTkrisp1234http://www.teradata.com/teradataforum/Topic12318-9-1.aspxhi dearI have designed this in TD itself...........And substr will work in TD as wellSubhashThu, 31 Jul 2008 15:13:33 GMTgander_sshttp://www.teradata.com/teradataforum/Topic12318-9-1.aspxHi Subash:Thankyou so much for ur wonderful reply. really appreciate thatBut my database is teradataI guess substr is not working on teradataany improvements in query to work well in teradata?ThanksThu, 31 Jul 2008 12:00:40 GMTkrisp1234http://www.teradata.com/teradataforum/Topic12318-9-1.aspxFollow this steps :step 1: create table table2 (tablename varchar(50),cnt integer)step 2 : select k.x from (Select substr('''',1,1)||a.tablename||substr('''',1,1) c, a.tablename q, ',count(*) from '||q p,'insert into table2 select'||' '||c||p||';' xFrom (Select Distinct Trim(databasename)||'.'||Trim(tablename) tablenameFrom dbc.tablesWhere tablekind='T') a) kstep 3: run this result set in one shot.Here I have taken example of all the database table u can modify u'r query accordingly.Regards,SubhashThu, 31 Jul 2008 01:20:41 GMTgander_sshttp://www.teradata.com/teradataforum/Topic12318-9-1.aspxHi I have bunch of tables collected from a database and tabulated them in a tableCould you please let me know what is best sql or method to get record countson each table in the table i created and listed themthanksMon, 28 Jul 2008 17:46:06 GMTkrisp1234