Skip to content

Instantly share code, notes, and snippets.

@timabell

timabell/schema-doc-properties.sql

Last active September 13, 2021 09:00
Show Gist options
  • Save timabell/f5580f04ea9cc0ac5746 to your computer and use it in GitHub Desktop.
Save timabell/f5580f04ea9cc0ac5746 to your computer and use it in GitHub Desktop.
Download ZIP
templates for addings sql server schema documentation
Raw
schema-doc-properties.sql
-- templates:
-- table description:
exec sys.sp_addextendedproperty @name=N'MS_Description', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',
@level1name=N'TableNameHere', @value=N'Table description here'
-- column description:
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level2type=N'COLUMN',
@level1name=N'TableNameHere', @level2name=N'ColumnNameHere', @value=N'Column description here'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment