What are my tables?

From SQLZOO
Revision as of 12:44, 11 July 2012 by Connor (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Get a list of all tables

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.

CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10));
INSERT INTO bbc VALUES ('Poland', 'Europe');
INSERT INTO bbc VALUES ('Japan', 'Asia');
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'

Template:Meta Data Ref

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense