Thank you very much for your response.The following Script worked absolutely fine.
Declare @OldOwner varchar(100), @NewOwner varchar(100)
set @OldOwner = 'dbo'
set @NewOwner = 'sys'
select 'sp_changeobjectowner ''[' + table_schema + '].[' + table_name + ']'', ''' + @NewOwner + '''
from information_schema.tables where Table_schema = @OldOwner
I am new to SQL programming. Could you please suggest me any online tutorial or link to learn the script you have used here? I greatly appreciate your help.