Difference between revisions of "What are my tables?"

From SQLZOO
Jump to: navigation, search
Line 8: Line 8:
 
<source lang=sql class='tidy'>
 
<source lang=sql class='tidy'>
 
</source>
 
</source>
 +
<source lang=sql class='setup'></source>
 
<source lang='sql' class='def e-sqlite'>SELECT * FROM sqlite_master
 
<source lang='sql' class='def e-sqlite'>SELECT * FROM sqlite_master
 
WHERE type='table'
 
WHERE type='table'

Revision as of 14:02, 12 July 2012

Get a list of all tables

schema:scott

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'