SQL Server

SHARE:

SQL Server script to find and change schema ownership

March 23, 2023 by Chris Straw

SELECT *,
'ALTER AUTHORIZATION ON SCHEMA::' + QUOTENAME(SCHEMA_NAME) + ' TO db_owner;'
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_OWNER = 'OwnerUserHere'

Written by

Chris Straw