SQL Server – How to get all columns name list with Database Name, Table Name, Schema and other details

Run the below script and see the result.

SELECT [TABLE_CATALOG]

      ,[TABLE_SCHEMA]

      ,[TABLE_NAME]

      ,[COLUMN_NAME]

      ,[ORDINAL_POSITION]

      ,[COLUMN_DEFAULT]

      ,[IS_NULLABLE]

      ,[DATA_TYPE]

      ,[CHARACTER_MAXIMUM_LENGTH]

      ,[CHARACTER_OCTET_LENGTH]

      ,[NUMERIC_PRECISION]

      ,[NUMERIC_PRECISION_RADIX]

      ,[NUMERIC_SCALE]

      ,[DATETIME_PRECISION]

      ,[CHARACTER_SET_CATALOG]

      ,[CHARACTER_SET_SCHEMA]

      ,[CHARACTER_SET_NAME]

      ,[COLLATION_CATALOG]

      ,[COLLATION_SCHEMA]

      ,[COLLATION_NAME]

      ,[DOMAIN_CATALOG]

      ,[DOMAIN_SCHEMA]

      ,[DOMAIN_NAME]

  FROM [INFORMATION_SCHEMA].[COLUMNS]

There are many other way to get the same result in SQL Server, if you can find than please share with me.