テーブル一覧
テーブル一覧取得
SELECT
B.NAME AS OWNER,
A.NAME,
A.TYPE
FROM
sysobjects AS A
INNER JOIN
sysusers AS B
ON
A.UID = B.UID
WHERE
A.TYPE IN ('U', 'IF', 'TF', 'V')
AND A.STATUS >= 0
ORDER BY
A.TYPE, A.NAME
gauchedavinci
http://www.gauchedavinci.com/
テーブル一覧取得
SELECT
B.NAME AS OWNER,
A.NAME,
A.TYPE
FROM
sysobjects AS A
INNER JOIN
sysusers AS B
ON
A.UID = B.UID
WHERE
A.TYPE IN ('U', 'IF', 'TF', 'V')
AND A.STATUS >= 0
ORDER BY
A.TYPE, A.NAME
gauchedavinci
http://www.gauchedavinci.com/