http://www.programmersheaven.com/ Contains the latest posts from the thread 'How to list all tables existing in ms access and column total' posted on the 'VB.NET' forum at Programmer's Heaven. en Copyright 2013 Programmers Heaven Sat, 18 May 2013 03:02:56 -0700 Sat, 18 May 2013 03:02:56 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 http://www.programmersheaven.com/images/ph.gif http://www.programmersheaven.com/ 88 31 http://www.programmersheaven.com/mb/VBNET/429372/429372/how-to-list-all-tables-existing-in-ms-access-and--column-total/ Please help me with this <br /> <br /> I want to list all tables in sql server compact 3.5 database and total of a specific column (I have a column name "total" in all tables).I found sql statement that returns list of table names but how do I get a column sum from all tables and place next to corespoding table? <br /> <br /> I have tried so far <br /> <br /> <pre class="sourcecode">select table_name from information _schema.columns where column_name=”total” </pre><br /> any bit of info would be helpful<br /> http://www.programmersheaven.com/mb/VBNET/429372/429372/how-to-list-all-tables-existing-in-ms-access-and--column-total/ Tue, 28 Aug 2012 20:22:10 -0700 VB.NET