Tüm databaselerde tüm tabloları bulmak

Tüm databaselerde tüm tabloları bulmak;

SET NOCOUNT ON

DECLARE @AllTables table (CompleteTableName nvarchar(4000))

INSERT INTO @AllTables (CompleteTableName)

    EXEC sp_msforeachdb 'select @@SERVERNAME+''.''+''?''+''.''+s.name+''.''+t.name from [?].sys.tables t inner join sys.schemas s on t.schema_id=s.schema_id'

SET NOCOUNT OFF

SELECT * FROM @AllTables ORDER BY 1