本文展示了如何使用SQL查询语句从系统中获取指定用户拥有的所有表名，通过内连接和子查询来筛选出符合条件的表。
select distinct sysobjects.name as SP_name --,*
from syscolumns inner join
sysobjects on syscolumns.id = sysobjects.id
and syscolumns.ID in
(SELECT id FROM sysobjects as a
WHERE OBJECTPROPERTY(id, N'IsTable') = 1) and uid =1
--and sysobjects.name like 'e%' and uid =1
order by SP_name
from syscolumns inner join
sysobjects on syscolumns.id = sysobjects.id
and syscolumns.ID in
(SELECT id FROM sysobjects as a
WHERE OBJECTPROPERTY(id, N'IsTable') = 1) and uid =1
--and sysobjects.name like 'e%' and uid =1
order by SP_name
扫一扫
6952
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
