Change Owner of the Tables of a BD

Description:

In MS SQL, you can change the owner of the tables in the current database.

Process:

If we want to manually establish the owner of a table (or in general of any object) of MS SQL we can resort to a script. Just open the query analyzer and write the following command:

ALTER SCHEMA dbo TRANSFER [current_owner] .tablename;



Where...

current_owner = Replace with the name of the current user owner of the table
tableare = Replace with the name of the Table
dbo = Replace with the new user of the Database

More information:

Alveni Cloud is not responsible for the loss of data and / or the mishandling of information by the user.