T-SQL Script ... list all tables owned != dbo
by Geoff on Nov.12, 2007, under Coding, SQL
DECLARE @oldOwner sysname, @newOwner sysnameSELECT @oldOwner = 'old_owner'
, @newOwner = 'dbo'
select 'EXECUTE sp_changeobjectowner '''+QUOTENAME(a.TABLE_SCHEMA)+'.'+QUOTENAME(a.TABLE_NAME)+''','''+@newOwner+''''
from
INFORMATION_SCHEMA.TABLES a
where
a.TABLE_SCHEMA = @oldOwner
AND
OBJECTPROPERTY(OBJECT_ID(QUOTENAME(a.TABLE_SCHEMA)+'.'+QUOTENAME(a.TABLE_NAME)), 'IsMSShipped') = 0
-
Hi! Welcome to Epic Puck!
Thanks for dropping by! Feel free to join the discussion by leaving comments, and stay updated by subscribing to the RSS feed. See ya around!
GM-VOLT : Chevy Volt Electric Car Site- Low-cost Revolo bolt-on, plug-in hybrid system touted for its potential
- A time to reflect on the Volt — my first fill up
- Chevrolet Volt and Vauxhall Ampera win Diesel Car’s Best Eco Car of the Year
- Consumer Reports says Volt and Focus EV compromised, unlike ‘purpose-built’ EVs
- Electric Vehicle Symposium (EVS26) Report
