The collations view provides information about the collations available in the current database.
| Column name | Data type | Description |
|---|---|---|
collation_catalog |
sql_identifier |
The name of the current database containing the collation. |
collation_schema |
sql_identifier |
The name of the schema containing the collation. |
collation_name |
sql_identifier |
The name of the default collation. |
pad_attribute |
character_data |
Specifies the padding behavior for the collation. Always NO PAD. |