Compare Table Structure in SQL Server 2005

[Lost User]

Hi Experts i am using sql server 2005. i Have a table with Five Field structure Give Below Col Name Data type Code int Name varchar Address varchar Fee Decimal AddDate DateTime Now Suppose i change the Structure of the table like Col Name Data type Code int Name varchar Fee Decimal AddDate DateTime Address varchar and Save It now i want to Compare Stucture of Last modified and Current Table and know the alter position of the column name Dinesh Sharma

[Mycroft Holmes]

Take a look at the system views, they have all this information. Columns have an ordinal position! If you are looking at synchronising the databases then look at the Red-Gate tools

Never underestimate the power of human stupidity RAH