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, ...
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,...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server-2008-r2 × 3794sql-server × 2628
t-sql × 356
sql-server-2008 × 338
performance × 219
sql-server-2012 × 170
backup × 123
index × 112
replication × 111
permissions × 104
ssis × 96
ssms × 95
query-performance × 83
security × 74
transactional-replication × 71
sql-server-2014 × 70
restore × 70
sql-server-agent × 66
stored-procedures × 65
linked-server × 63
transaction-log × 61
mirroring × 56
sql-server-2005 × 52
database-design × 51
index-tuning × 50