How to document SQL Tables using SQL Management Studio

How to document SQL Tables using SQL Management Studio

  1. Paste this query in SQL Management Studio.  The query use the system catalog views which show the table attributes of the tables. Change the db to respective db
  2. USE [db];

    SELECT OBJECT_SCHEMA_NAME(T.[object_id],DB_ID()) AS [Schema],
    T.[name] AS [table_name], AC.[name] AS [column_name],
    TY.[name] AS system_data_type, AC.[max_length],
    AC.[precision], AC.[scale], AC.[is_nullable], AC.[is_ansi_padded]
    FROM sys.[tables] AS T
    INNER JOIN sys.[all_columns] AC ON T.[object_id] = AC.[object_id]
    INNER JOIN sys.[types] TY ON AC.[system_type_id] = TY.[system_type_id] AND AC.[user_type_id] = TY.[user_type_id]
    WHERE T.[is_ms_shipped] = 0
    ORDER BY T.[name], AC.[column_id]

  3. SQL01Right click and choose save the result as csv file and open this in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *