I already have:

select * from mydb.dbo.syscolumns as cols where id=OBJECT_ID('mydb.dbo.mytable')

to get the structure of each table, but how would I compare two of these directly in the stored procedure as a fail-safe prior to running my archive code?