Script Check

[Mustafa Ismail Mustafa]

I just want to double check if this script is on the right track.

select t.name, count(c.column_id) as columns
from sys.tables as t
inner join sys.columns as c on t.object_id = c.object_id
where schema_id = (select schema_id from sys.schemas where sys.schemas.name='EMR') -- Alter Schema name
group by t.name
order by [name] asc

Basically I want to check for altered tables between two different databases, this ought to pull out all the tables in a schema and the number of columns for each table. Obviously, any changes on the table that don't affect the number of columns, I will not be alerted of.

If the post was helpful, please vote, eh! Current activities: Book: Devils by Fyodor Dostoyevsky Project: Hospital Automation, final stage Learning: Image analysis, LINQ Now and forever, defiant to the end. What is Multiple Sclerosis[^]?

[Mycroft Holmes]

I prefer to use the information schema view - 'cause I can.

SELECT Table_Name, COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'STG'
GROUP BY Table_Name

[Mustafa Ismail Mustafa]

See, this is why I love this site :-D I like your script better and will steal it! Now , to figure out how to realize that there are changes!

If the post was helpful, please vote, eh! Current activities: Book: Devils by Fyodor Dostoyevsky Project: Hospital Automation, final stage Learning: Image analysis, LINQ Now and forever, defiant to the end. What is Multiple Sclerosis[^]?