List of Table, Columns, and Column Data types 2

[mts176]

I currently have 3 seperate databases, at three office locations, that "should be" the same. We are doing an audit on our Intranet, everything from pages of code to database structure, to make sure that everything is the same. Or at least somebody in the other offices didn't do anything drastic to the database.

Is there a way I can write a Query that will return all of the Table with all of the column names and with the column data types?

Currently I am trying to use the SQL Diagram function, and it is wasting to much time and effort.

Any help would be greatly appreciated.

 

[dbomrrsm]

This might help

select *
from information_schema.columns
where TABLE_CATALOG = 'MY_DATABASE_NAME'

 

[mts176]

Fantastic, this is just what I needed. Thank you very much.
DBomrrsm