SQL Server Performance Forum – Threads Archive
Rename schemaHi! I have installed the sql server 2005 2005 ctp and want to work with the sql managment studio. I habe a database with some tables named as username.articles, username.ratings and so on. The username is the schema. I want to rename the username.articles to dbo.articles but habe no idea how to. I can only rename the "article" but have no acces to the username schema prefix. Habe anyone an idea how to rename this schema prefix?
i feel username is owner name for the table articles.
U can change the owner by using pre supplied SP in sql 2000.
About 2005 have not much idea.
In sql 2000 u can use sp_changeobjectowner.