dbo.dbo. sp_rename error

[fredong]

Hi,
I accidentally rename dbo.AA table to dbo.AA_1 and now it has become dbo.dbo.AA_1 table. Is there a way to remove the dbo prefix? Please advise. Thanks.

 

[SQLBill]

Rename the table again? Change it to just AA_1. Leave off the dbo when you rename it.

OR...create a new table AA_1. Copy the data (SELECT INTO) from the bad table to the new one, then drop the old table.

-SQLBill

Posting advice: FAQ481-4875

 

[fredong]

I tried this statement and it returned 'invalid object name dbo.dbo.AA'


select * into dbo.AA_1 from dbo.dbo.AA

it seemed like the dbo.dbo. cannot be recognized by the system.

 

[gmmastros]

Normally, you cannot have a table name with a dot in it. Of course, you can actually name your tables anything you want if you use square brackets, like this...

select * into dbo.AA_1 from dbo.[!][[/!]dbo.AA[!]][/!]




-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[fredong]

Hi gmmastros

Thanks for your help. It works.

 

[gmmastros]

You do know that Select Into will only copy the data, don't you? The new table will not have the same indexes or constraints as the original table. There are probably other things that don't get copied to the new table too.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[fredong]

Thanks for letting me know. I have not build queries for those table yet and I probably index it later.

 

[SQLDenis]

why don't you just rename it back

doesn't this work???


sp_rename 'dbo.[dbo.AA]' , 'dbo.AA_1'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/