SQL Server Performance

Rename schema

Discussion in 'SQL Server 2005 General DBA Questions' started by newsql, May 6, 2005.

  1. newsql New Member

    Hi!

    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?
    Thanks!!
  2. ranjitjain New Member

    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.
  3. newsql New Member

    thx,
    that works!

Share This Page