Skip to content

Instantly share code, notes, and snippets.

@shermaza

shermaza/tables.sql

Created May 8, 2018 20:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save shermaza/11d2bb875a087185076d3bad5312c263 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save shermaza/11d2bb875a087185076d3bad5312c263 to your computer and use it in GitHub Desktop.
Download ZIP
List all tables in a schema
Raw
tables.sql
SET @schema_name = 'magento';
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='BASE TABLE'
AND TABLE_SCHEMA=@schema_name;
@shermaza
Copy link
Author

shermaza commented May 8, 2018

In this case, the schema name is 'magento'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment