What are my tables?
From SQLZoo
Get a list of all tables
schema:gisq
We should expect to find a system table that includes a list of tables. We should expect this to contain a great deal of extra data that is hard to understand.
SELECT * FROM sqlite_master
WHERE type='table'
SELECT * FROM syscat.tables
WHERE tabschema = 'SCOTT'
SELECT Name FROM MSysObjects
WHERE Type=1 AND Flags=0
SELECT tablename FROM pg_tables
WHERE tableowner = current_user
SELECT * FROM cat
SELECT * FROM sysobjects
WHERE xtype='U'
show tables
SELECT * FROM information_schema.tables
WHERE table_type='BASE TABLE'
SELECT * FROM sysobjects
WHERE type='U'
