Documenting Your Microsoft SQL Server Data Warehouse

mssql.sql

create table orders (
    id int
)
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description', 
   'This table holds all customer orders!',
   'user', @CurrentUser, 'table', 'orders'
go

select value
from fn_listextendedproperty (null, 'schema', default, 'table', 'orders', default, default);
go
┌───────────────────────────────────────┐
│                value                 |
├───────────────────────────────────────┤
│ This table holds all customer orders! │
└───────────────────────────────────────┘