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, ...
user avatar
  • 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,...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible