How to generate MySQL data dictionary from SQL script скачать в хорошем качестве

How to generate MySQL data dictionary from SQL script

Sure, you can use MySQL Workbench, or Toad, or a similar IDE to generate a data dictionary from an application. But what if you don't have those applications? Or what if you want a more universal way of generating a data dictionary? Then the following SQL script is for you. This script will return the schema and table names as well as numerous column properties beyond just the column name. It also includes the column's ordinal position, whether or not it is a part of a primary key / foreign key / unique key, its data type and various length/size/precision components, whether or not it is nullable, and the description. This short video walks you through downloading the script, executing it, pulling the metadata into an Excel file where it can easily be formatted to look pretty and shared with other team members via email. ------ Chapter Timestamps (click to jump forward): ---------------------------- 0:00 - Intro 0:09 - Ever Needed to Troubleshoot What Schema Change Broke Your App? 0:39 - Demo: How to Download the Script 1:27 - Demo: How to Run the Script and Generate the Data Dictionary 2:54 - Demo: The Data Dictionary output in Excel 4:25 - The End Download: https://raw.githubusercontent.com/Dat... Watch related playlist videos:    • Oracle SQL Scripts for Data Analysts   Connect with me on social media: LinkedIn:   / mpiercead576   YouTube:    / @dataresearchlabs   GitHub: https://github.com/DataResearchLabs Subscribe to my YouTube Channel:    / @dataresearchlabs   Background Music (via YouTube "always free" Audio): "Rewind" by Ofshane:    / @ofshane   #MySQL #datadictionary #autogenerate