Software >> Services >> RDBMS >> SQL Server >> How to change the owner of a table

eg. table HRS_table1 owned by hrs, of type User, to change it to be owned by 'dbo' role instead, use <databasename> sp_changeobjectowner 'hrs.HRS_table1','dbo'