便利SQL

テーブルカラム一覧

SELECT
     c.name
FROM
     syscolumns AS c
    ,sysobjects AS o
WHERE
     o.id = c.id
AND  o.name = 'テーブル名'
ORDER BY
     c.colorder

ストアドのソース

SELECT 
     c.text
FROM
     syscomments AS c
    ,sysobjects  AS o
WHERE  
     o.id = c.id
AND
     o.name = 'ストアド名'

テーブルコピー

SELECT
     *
INTO
     tbl_bk
FROM
     tbl

あらかじめtbl_bkを作成しておく必要はないが
"制約"はコピーされないので注意