How to use SQL Schema to Data Dictionary
- Paste supported CREATE TABLE statements.
- Run the parser and address any unsupported construct.
- Review column and constraint details, then download the dictionary or templates.
Example: SQL Schema to Data Dictionary
Describe two declared columns.
Options
- SQL source
- Paste supported CREATE TABLE declarations. The parser reports declared columns and constraints; it does not query a server or validate every SQL dialect.
Supported inputs and limits
Where your input is processed
This tool processes your input in this browser. Your text and files are not uploaded to UseFreeTools. Check this tool's limits for anything it may save on your device.
A dictionary describes supplied declarations
The report cannot prove the current production schema matches the pasted SQL. Defaults and constraints are reported from the supported syntax rather than executed. Compare the dictionary with an actual schema export when current database evidence matters.
Unsupported syntax should remain explicit
Complex dialect extensions and expressions can be outside the bounded parser. Do not treat a partial-looking dictionary as a complete migration review. Resolve a refusal with the declared supported subset or use the database tooling for that dialect.
Questions about SQL Schema to Data Dictionary
Can it read any SQL dump?
No. Paste supported table declarations only. Other statements and unsupported clauses are refused.
Does the template include database data?
No. It contains column headers without records, for preparing an import.
Are types converted to a common database type?
No. The dictionary retains the declared type text so it does not silently reinterpret your schema.