This was awesome once i figured out i had to drop the schema.table name syntax from

select c.name, c.xtype, c.status

from syscolumns c

inner...