Automate table name modifications

[roman2]

Some (if not all, I don't know for sure… at least, mine) hosting providers force a prefix onto table names. I would like to have an easy way to modify table names (all at once and maybe selected ones).

[Ritesh]

Thanks.

I have forwarded your issue to my development team.

[roman2]

I should have been more explicit — by modification I mean not only adding a string to a name (in front or end of an existing name) but also removing it too. This would make it easier to move from one host to another.

[Ritesh]

We need to use Alter Table… SQL to modify information about tables. There is no option in Alter Table to work on multiple tables.

[peterlaursen]

I don't think it' common that you should use a prefix with each table – just the database and the user(s)

[roman2]

My provider requires it, and they claim having tens of thousands of clients. Perhaps, this is common enough to justify adding this feature to SQLyog.

[Author]

Posts