Find collation of database [SQL SERVER]

/ Updated : / 0 Comments

SQL Server Find Collation of Database: Here in this article we see how to find the collation of particular Database in 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 table from two different Database Server. This joins works only if both SQL Server table have same collation and for that first we need to view its collation.

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

SQL QUERY: To View Collation of Database in SQL SERVER

SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation') 


Output:

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 do a favor, then 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 *

Comments