Cesar L. Meloni wrote:

> Can I change a table name?

Short answer NO

> I need change it, and have a lot of relations with others...

Which is why NO
The correct method - or at least one that will work without causing any
problems.
Create new table, copy data over to new table
Update all relations to use new table
Drop old table - if it complains then there are still links that need
tidying - which is why you don't want 'DROP' just to drop everything :)

Because of the much more complex arrangement of relations over 'simpler'
database engines, a quick 'change name' will probably not be possible
any time soon, and could lead to other problems, which the long winded
route at least allows the chance to correct before the data is messed up
completely ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services