How to rename an entity's internal name

How to rename an entity's internal name

  
Hi,

I need to rename an entity's internal name, the one used to create the sql table, to have the same names on Service Studio and SQL Manager.

Is this possible?

Thanks,
Pedro
Solved it!

Here's how I did it:
1. Changed entity names on Service Studio and published the eSpace;
2. Duplicated the bd;
3. Edited by hand the physical_table_name on the sql table ossys_Entity;
4. Dropped the tables;
5. Re-published the eSpace
6. Created and run a script to migrate data from the backup db to the tables with new name.
Regards,
Pedro
Hi Pedro,

Although you may have solved your problem, you may also read this related topic:
http://www.outsystems.com/NetworkForums/viewtopic.aspx?TopicId=3444

Also, if your goal is simply having more ease executing queries or managing tables in SQL Management Studio, maybe this tool is enough for translating between logical and physical table names:
http://www.outsystems.com/NetworkForums/viewtopic.aspx?TopicId=2943
Thanks Paulo,

I had looked into those two posts.

My problem was a real name change in entities, e.g: from "issue" to "incident".

Thanks for the tip, I'll use the SQL Map eSpace for sure, it's a very handy tool!

Pedro