How to change table name.

[archanajoshi]

Hi All,

I need to change table.

I have tried though elevated role "Security_admin" but no luck.

Please help.

Thanks,

Archana Joshi.

[Uncle Rob]

Don't think there's a way to rename a table.   Re-label, yes.   Rename, no.

[archanajoshi]

Hi Robert,

Any chance of getting this through Background scripts or something.

Please help.

Thanks,

Archana Joshi.

[Uncle Rob]

Man I don't know if I could recommend in good conscience even if I *did* know.   First, I'm not sure if other building blocks that reference table do so in a conventional way... meaning renaming a table could potentially orphan any and all business rules associated with it.   And that's before we even start talking about scripts that have the table name typed out manually.

[Chuck Tomasi]

Robert is correct. Don't try this through scripts - background either. There are other tables that manage/reference tables.

If you are still in dev, then definitely delete and recreate. If you're in production, do the same in dev, but before promoting to production, export the data to XML. If you're brave and talented, you can do a search/replace of the XML file of old table name with new table name and preserve your info. Remember - always test in a non-production instance first!