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')
Here in my case its shows SQL_Latin1_General_CP1_CI_AS you may also get Latin1_General_CI_AS