Renaming a table

Question

Renaming a table

BuilderBits

SSCertifiable

Points: 6071
More actions
July 7, 2005 at 5:54 pm

#165160

Hello Again,
I am tring to rename a table and i am getting an error that says (This object can not be renamed)However i am able to rename it to something other than what i need to rename it to.
For example: The name of the table now is ProdcutRestrictions (and if you'll notice i misspelled Product) and i am wanting to name it to ProductRestrictions.
Erik...
Dam again!

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

David Webb-CDS SSCoach Points: 17398 More actions · Answer 1

Is there another object in the database already named ProductRestrictions (proc,view,trigger,...)? That's the only reason I can think of that it might accept one name but not the one you want.

And then again, I might be wrong ...
David Webb

BuilderBits SSCertifiable Points: 6071 More actions · Answer 2

I was not aware that a table and a proc could not have the same name,

It was a proc that i named ProductRestrictions.

Thank You,

Erik...

Dam again!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Any object means :

Unique constraint

Primary key

table

trigger

user defined function

defaults

check constraints

Fk

views

extended procs --for master only

replication functions

Indexes can have the same name as the table or any other objects.

Did I forget anything?

BuilderBits SSCertifiable Points: 6071 More actions · Answer 4

Looks like you have just about got it all coverd,.

I am working on a datagrid right now, and i have found that formating datagrids and datalist are a pain in the A_ _... I guess that is why there is so many third partys out their that offer different datagrids.

Erik....

Dam again!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

I'll take your word on this one... I never really worked with those (simple databind() but that's about it).

Gift Peddie SSC Guru Points: 73570 More actions · Answer 6

Next time look into ANSI SQL ALTER TABLE statement. In the meantime try these links for good datagrid code the first link is two parts, but a datalist is more flexible. Hope this helps.

http://www.dotnetjunkies.com/Tutorial/EA868776-D71E-448A-BC23-B64B871F967F.dcik

http://www.codeproject.com/aspnet/elphGrid.asp

Kind regards,

Gift Peddie

Kind regards,
Gift Peddie

BuilderBits SSCertifiable Points: 6071 More actions · Answer 7

Thank you for the links i will check them out...

Dam again!

BuilderBits SSCertifiable Points: 6071 More actions · Answer 8

Will do. Right now i am tring to get a grip on the update and delete of data from a datagrid so that i can enter my application data quickly.

I have way to much information to enter to be tring to do it through the sql2000 directly. So i am making an application just for entering data into the table object of choice.

Is this the right thing for me to do?, are do you know of a better way?

Erik...

Dam again!