SQL Server 2005 features in comparing DB schema /tables

Question

Is it possible to create or do it from SSMS to compare two different schema ?

I need to compare database table in my current production DB to see which one is different in order to generate delta (upgrade script)

Thanks.

Answer 1

No, SSMS doesn't have a feature to do this. Look at RedGate or Quest for a tool to do this.

Answer 2

but then I found this

select TABLE_SCHEMA,COUNT(*) TableCount from INFORMATION_SCHEMA.TABLES group by TABLE_SCHEMA -- followed by select * from sys.tables order by modify_date desc

but that's just a simple script to list all tables between my prod and dev environment.