Listando todas as tabelas dos usuários no SQL Server

[sourcecode lang=”sql”]
SELECT
so.name
FROM
sysobjects so
WHERE
so.xtype = ‘U’ AND
so.name <> ‘dtproperties’
GROUP BY
so.name
[/sourcecode]

Posts relacionados