What does COLLATE Keyword in SQL signify, in MS SQL Server?

Answer 1

The COLLATE key word is used to set the collation of the database or table.
Collation:
Collation defines in the way that the data is sorted. we all know that creating indexes will sort the data in a particular order. There are various collation to sort the data it is normally used when we are storing multilingual data, like if our data is in Hindi then it cannot be sorted in A,B,C,D.... order rite? so there is a collation for Indic languages that defines in which order to sort the data.

Answer 2

Collation is the basic criteria provided or incorporated on the table or database or on the column whether that particular object should have case sensitiveness or not.

CREATE TABLE [dbo].[sample](
                  [id] [int] IDENTITY(1,1) NOT NULL,
                  [name] [varchar](20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]

name is the column which has the case sensitiveness propert.

Answer 3

Clause that can be applied to a database definition to define the collation.
Syntax

COLLATE < collation_name >
< collation_name > :: =
< Windows_collation_name >
< Windows_collation_name >:: =
CollationDesignator_< ComparisonStyle >
< ComparisonStyle > :: =
CaseSensitivity_AccentSensitivity

Regards
Sridhar R
Nothing is illegal, Until You Get Caught
-Sridhar R