Closed burmanm closed 11 years ago
SELECT s.name + '.' + t.name AS table_name, t.object_id AS object_id FROM sys.tables AS t INNER JOIN sys.schemas AS s ON s.schema_id = t.schema_id
SELECT s.name + '.' + t.name AS table_name, t.object_id AS object_id FROM sys.tables AS t INNER JOIN sys.schemas AS s ON s.schema_id = t.schema_id