1
vote
Changing table name from upper to lower case
In addition to what David said, changing the table name, even just to change the casing, won't update your objects that reference that table in a query. I.e. any views, procedures, functions, etc, ...
- 24.6k
1
vote
Changing table name from upper to lower case
If the database collation is case-insensitive then it could be changed, I'd check the server collation, too just in case.
SELECT name, collation_name FROM sys.databases.
CI indicates case-insensitive,...
- 49
Only top scored, non community-wiki answers of a minimum length are eligible