CODEWITHSUNDEEP
sqlsql-serversql-server-2008sql-server-2012
JAN
JAN

Reputation: 21895

How to remove or alter the dbo prefix from SQL Server 2012 tables?

Someone already had asked this question here but didn't get an answer for that question .

How can I change a table in SQL Server 2012 that starts with a dbo prefix to one without ?

Upvotes: 7

Views: 19065

Answers (3)

Hardik Solgama
Hardik Solgama

Reputation: 13

Below is the answer for removing or replacing the prefix in the dbo.

ALTER SCHEMA dbo TRANSFER [PrefixName].[salesorder]

Upvotes: 0

Roya Kianbakht
Roya Kianbakht

Reputation: 21

change > mydb.tableName to dbo.tableName

1 .Click F4 or ( view > Properties window) , 2 .then click on your Table. 3 .in properties window , in schema field , change the attribute.

Upvotes: 2

JAN
JAN

Reputation: 21895

Here is the answer (alter !!!) , for anyone that might need it someday : 

IF (NOT EXISTS (SELECT * FROM sys.schemas WHERE name = 'MyDbo')) 
BEGIN
    EXEC ('CREATE SCHEMA [MyDbo] AUTHORIZATION [dbo]')
END

ALTER SCHEMA MyDbo 
    TRANSFER dbo.your_old_table
GO

Upvotes: 3

Related Questions