Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MainSystem
Starting Member
7 Posts |
 Posted - 2007-12-16 : 18:39:37
|
Anyone konw How to remove dbo prefix from table name in sql 2005 ??    |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-12-16 : 19:34:08
|
You can change the owner of the table to another owner...sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'you must be the database owner, or have the correct admin rights to execute the statement.However, you cannot "remove" the tables owner prefix entirely...the table must have an owner.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-16 : 20:19:55
|
| Why do you want to do that in first place? |
|
|
|
MainSystem
Starting Member
7 Posts |
Posted - 2007-12-16 : 20:35:35
|
| ha cuz my applications written without "dbo.table" althought they work fine now , but i'm worry some how , i like to remoce that ugly dbo !!! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-16 : 21:45:19
|
| You don't have to call table with dbo.table since dbo is default schema. If you change owner to other schema, then you have to call it as schema.table. |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-12-16 : 21:52:45
|
THe OP contacted me via IM. Issue is related to migrating of Access DB to SQL Express for a web app supported by dreamweaver. Apparently the dbo. prefix is causing issues as it was not there, or needed, in the Access version.Issue is resolved.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
|
|
|
How to remove dbo prefix from table name ?