it's not a ideal way, but you can backup your data to a csv file, rename the table, and import the csv.
2010/7/14 yamandu <[email protected]> > Well, I´ve got in situation that could not ocurr but situations seem > not to respect some rules. > > I need simply to rename a table. > I can imagine some ways to do that. > > I tried rename in MySql and rename respective .table file but didn´t > worked. > I gives me error with keys. > > Another way I think is create another table with the new name and copy > everything. > I think this is inneficient and might not work because of the ID if I > use DAL. > Use SQL so? And .table file? > -- Atenciosamente -- ========================= Alexandre Andrade Hipercenter.com
