Is it possible to rename a table in a database without loosing any data?
I have a name which was OK when I first started but now it makes more sense to rename the table with a more appropriate name. Yes, it would require changing a lot in the script-- but as a hypothetical?