How to generate a Data Dictionary? скачать в хорошем качестве

How to generate a Data Dictionary?

In this video we cover a question that came in from a client last week - Can we generate a Data Dictionary from a query? The answer is Yes! and I will show you how to do it in SQL Server and Oracle! SQL Server method select TABLE_CATALOG, table_schema, table_name, column_name, data_type, is_nullable, column_default, character_maximum_length, numeric_precision, numeric_scale, datetime_precision from INFORMATION_SCHEMA.columns where Table_CATALOG='ACME' order by table_name, ordinal_position; Oracle method select owner TABLE_CATALOG, owner table_schema, table_name, column_name, data_type, nullable is_nullable, data_default column_default, data_length character_maximum_length, data_precision numeric_precision, data_scale numeric_scale, data_length from all_tab_columns where owner='ACME' order by table_name, column_id Join my SQLAnswers skool - an online community with direct access to myself and other Data Pros! https://www.skool.com/sqlanswers-skoo...