delete
delete

Reputation:

Deleted a table, created it again, now it doesn't appear in the dbo

In SQL Management Studio, I deleted a table, and created it again using a SQL query. Now in code I cannot call it using dbo. something something. It just doesn't appear in the intellisense.

Any suggestions on how to make this work?

Edit: I can't delete the table again and RE create it with [dbo] tag. Any other solutions?

Upvotes: 0

Views: 104

Answers (1)

erikkallen
erikkallen

Reputation: 34411

ALTER SCHEMA dbo TRANSFER MyName.MyTableName

reference

Upvotes: 3

Related Questions