All columns of the INFORMATION_SCHEMA.COLUMNS
view are listed at Learn -> SQL -> SQL Server -> COLUMNS (Transact-SQL)::
COLUMN_NAME
is of data type nvarchar(128)
:
But there is no more metadata about this column. Which collation does it have?
Where is the documentation for all of the attributes of this column:
on the Microsoft sites?
or perhaps in some SQL Server menu itself? I have Server Management Studio. With DBeaver on a MySQL database, you can check the properties of any view or table with a right click so that you can see all of the column attributes. But MS SQL Server does not have this.
Or how can I ask for the
INFORMATION_SCHEMA.COLUMNS
view of theINFORMATION_SCHEMA.COLUMNS
view? Something like:select * from INFORMATION_SCHEMA.COLUMNS where c.TABLE_SCHEMA = 'INFORMATION_SCHEMA' and c.TABLE_NAME = 'COLUMNS'