Q&A for community managers, administrators, and moderators
SELECT name, schema_name(schema_id) as schema_name FROM sys.tables