Sybase获取所有用户表,以及所有者(owner)

select b.name+'.'+a.name AS name from sysobjects a,sysusers b
where a.uid=b.uid
and a.type='U'
ORDER BY b.name+'.'+a.name

 

posted @ 2015-10-23 20:50  逍遥子k  阅读(1971)  评论(0编辑  收藏  举报