Find collation of database [SQL SERVER]


SQL Server Find Collation of Database: Here in this article we see how to find the collation of a particular Database in the SQL server. Finding Collation of SQL Server is very helpful when you need to change the Collation at the Database Level.  Assume you have to join two different tables from two different Database Server. This joins works only if both SQL Server tables have the same collation and for that first, we need to view its collation.

If required we need to alter the collation of tables having different collations.

SQL QUERY: To View Collation of Database in SQL SERVER

SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation') 


Here in my case its shows SQL_Latin1_General_CP1_CI_AS you may also get Latin1_General_CI_AS 

Other Reference:  

Thank you for reading, pls keep visiting this blog and share this in your network. Also, I would love to hear your opinions down in the comments.

PS: If you found this content valuable and want to thank me? 👳 Buy Me a Coffee

Subscribe to our newsletter

Get the latest and greatest from Codepedia delivered straight to your inbox.

Post Comment

Your email address will not be published. Required fields are marked *