SQL Server check case-sensitivity?

by

Collation can be set at various levels:

  1. Server
  2. Database
  3. Column

So you could have a Case Sensitive Column in a Case Insensitive database. I have not yet come across a situation where a business case could be made for case sensitivity of a single column of data, but I suppose there could be.

Check Server Collation

SELECT SERVERPROPERTY('COLLATION')

Check Database Collation

SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation') SQLCollation;

Check Column Collation

select table_name, column_name, collation_name
from INFORMATION_SCHEMA.COLUMNS
where table_name = @table_name

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. SQL Server dynamic PIVOT query?
  3. SQL Server – Best way to get identity of inserted row?
  4. Should I use != or for not equal in T-SQL?
  5. How to update two tables in one statement in SQL Server 2005?
  6. SQL Server Process Queue Race Condition
  7. Create a date from day month and year with T-SQL
  8. How should I pass a table name into a stored proc?
  9. Is the NOLOCK (Sql Server hint) bad practice?
  10. SQL Server – How to lock a table until a stored procedure finishes
  11. Where value in column containing comma delimited values
  12. What is SYSNAME data type in SQL Server?
  13. SQL query to split column data into rows
  14. Pivot using SQL Server 2000
  15. How to drop SQL default constraint without knowing its name?
  16. Sequence vs identity
  17. How to update and order by using ms sql
  18. Dynamic update statement with variable column names
  19. How to select only the first rows for each unique value of a column?
  20. SQL Server (TSQL) – Is it possible to EXEC statements in parallel?
  21. Can I set ignore_dup_key on for a primary key?
  22. Unordered results in SQL
  23. Using PIVOT in SQL Server 2008
  24. How to find column names for all tables in all databases in SQL Server
  25. SQL Row_Number() function in Where Clause
  26. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  27. How do I compare 2 rows from the same table (SQL Server)?
  28. COALESCE Function in TSQL
  29. Convert bigint to datetime
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment