Howdy, Stranger!

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


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

isacisac Member Posts: 4
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.