Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gregoryagu
Yak Posting Veteran
80 Posts |
 Posted - 2008-07-16 : 10:48:45
|
| In working with SSMS, I find that identifiers are case sensitive. In searching the web on this, it says that it is because of the database collation being case sensitive. And indeed, looking up the collation says it to be SQL_Latin1_General_CP1_CS_AS.Is there a best practice with identifiers? ie, use only lowercase for table and column names to avoid issues with case sensitivity? The database I am working with uses proper case for table names and lower case for columns.Greg |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-16 : 10:53:45
|
| There's no hard and fast rule. But generally we use upper case for table names and proper cases for column names with different words seperated by _ symbol. |
 |
|
|
|
|
|
Case Sensitivity of Identifiers