I have dumped schema which has more than 100 tables.
And all the table names are in small case letters. Is there any faster way of converting names to uppercase letters?
Doing by one by one takes a long time.
Asked
Active
Viewed 16 times
0
-
Usually the case of table names and column names in relational databases are irrelevant. SQL is by design case insensitive. The key word is usually. Some implementations may be case sensitive. – Roslan Amir Apr 07 '22 at 01:22
-
_Table_ names map to file names, hence there is a BIG difference between Windows and Linux. _Collumn_ names don't matter. It is possible to write a query against `infomation_schema.tables` to generate the `ALTERs` needed. – Rick James Apr 08 '22 at 19:33