How to list all tables existing in ms access and column total - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How to list all tables existing in ms access and column total

isacisac Posts: 4Member
Please help me with this

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?

I have tried so far

[code]select table_name from information _schema.columns where column_name=
Sign In or Register to comment.