• Home
• us.fatehi
• schemacrawler-sqlserver
• 16.22.3
• source code
• ADDITIONAL_COLUMN_ATTRIBUTES.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

sqlserver.information_schema.ADDITIONAL_COLUMN_ATTRIBUTES.sql Maven / Gradle / Ivy

SELECT
  DB_NAME() AS TABLE_CATALOG,
  SCHEMA_NAME(O.SCHEMA_ID) AS TABLE_SCHEMA,
  O.NAME AS TABLE_NAME,
  C.NAME AS COLUMN_NAME,
  EP.VALUE AS REMARKS
FROM
  SYS.COLUMNS AS C
  INNER JOIN SYS.ALL_OBJECTS O
    ON C.OBJECT_ID = O.OBJECT_ID
  INNER JOIN SYS.EXTENDED_PROPERTIES EP
    ON EP.MAJOR_ID = C.OBJECT_ID AND EP.MINOR_ID = C.COLUMN_ID
WHERE
  O.IS_MS_SHIPPED != 1
  AND O.TYPE = 'U'
  AND EP.CLASS = 1
  AND EP.NAME = 'MS_Description'