列在目前使用的資料庫內所有資料表清單 use db

資料表清單:(U=使用者,S=系統)
SELECT sysobjects.id as id
,sysobjects.name as name
,sysusers.name as u_name
FROM sysobjects
left outer join sysusers on sysobjects.uid = sysusers.uid
WHERE sysobjects.xtype = 'U'
ORDER BY name