Question

0 0

如， select name, id, [uid] from sysobjects where type = 'u' ，这样可以查出所有的用户表，但是前面并没有schema的限定名，sql语句怎样查schema呢？要查那张表呢？

10 years, 8 months ago

share

我爱巨三鹿 10 years, 8 months ago

Answer 1

0

好吧，自己解决了。。。看系统表看的眼睛都瞎了。。。


 select name = '[' + s.name + '].[' + t.name + ']' from sys.tables t , sys.schemas s where t.schema_id = s.schema_id

answered 10 years, 8 months ago

share

shady answered 10 years, 8 months ago