data dictionary

data dictionary snippets.md

https://dataedo.com/product/data-dictionary-tool https://dataedo.com/kb/data-glossary/what-is-passive-data-dictionary https://www.slingshotapp.io/blog/data-catalog https://atlan.com/what-is-a-data-catalog/ https://atlan.com/what-is-a-data-dictionary/ https://www.octopai.com/data-dictionary-vs-business-glossary/ https://www.holistics.io/blog/get-on-top-of-company-data-create-a-data-dictionary/

data dictionary sql.md

sql server

CREATE TABLE Patient (
	Patient_ID bigint IDENTITY(1,1) NOT NULL,
	Patient_code varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	Patient_foo_bar varchar(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
);

-- Extended properties

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A person who meets the clinical OR epidemiological criteria acute onset of fever AND cough (ILI)', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'Patient';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'special code generated during quarantine. Must be greater than 5000', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'Patient', @level2type=N'Column', @level2name=N'Patient_code';

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'unde omnis iste natus error sit voluptatem accusantium', @level0type=N'Schema', @level0name=N'dbo', @level1type=N'Table', @level1name=N'Patient', @level2type=N'Column', @level2name=N'Patient_foo_bar';

result