Database Structure
Extract Database Metadata
Generate a metadata script, run it in your own database tool, and return the structural results to SQL Mocker.
Steps
1
Choose Extract Schema
Select the database system and enter the exact tables you want to include.
2
Copy the generated script
SQL Mocker creates a read-only metadata query for the selected database system and tables.
3
Run it in your database tool
Execute the script yourself using your normal database access controls. SQL Mocker does not establish the connection for this workflow.
4
Paste or upload the output
Return the script results to SQL Mocker and review the detected tables, columns, data types, keys, and relationships.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.