テーブル情報の取得

select
  a.name as テーブル名,
  a.id as テーブルid,
  b.name as 列名,
  b.xtype,
  c.name as データ型,
  b.length as サイズ,
  b.colid as 列順番
from
  (select name, id from sysobjects) a
  inner join
  (select name, id, xtype, length, colid from syscolumns) b
  on a.id = b.id
  inner join
  (select name, xusertype from systypes) c
  on b.xtype = c.xusertype
where
  a.name = @table

これで簡単な定義書作れそう。