Difference between revisions of "What are my tables?"

From SQLZOO
Jump to: navigation, search
 
Line 1: Line 1:
 
Get a list of all tables
 
Get a list of all tables
 
<div class='ht'>
 
<div class='ht'>
<div class=params>schema:scott</div>
+
<div class=params>schema:gisq</div>
 
<div>
 
<div>
 
We should expect to find a system table that includes a list of tables.
 
We should expect to find a system table that includes a list of tables.

Latest revision as of 14:39, 12 July 2012

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'
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense