What are my tables? - Revision history

Connor at 14:39, 12 July 2012

2012-07-12T14:39:41Z

Connor at 14:02, 12 July 2012

2012-07-12T14:02:20Z

Connor at 08:38, 12 July 2012

2012-07-12T08:38:20Z

Connor at 13:34, 11 July 2012

2012-07-11T13:34:27Z

Connor at 13:15, 11 July 2012

2012-07-11T13:15:54Z

Connor at 12:58, 11 July 2012

2012-07-11T12:58:51Z

Connor: Created page with "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 ..."

2012-07-11T12:44:22Z

Created page with "Get a list of all tables <div class='ht'> <div> 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 ..."

New page

Get a list of all tables
<div class='ht'>
<div>
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.
</div>
<source lang=sql class='tidy'>CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10));
INSERT INTO bbc VALUES ('Poland', 'Europe');
INSERT INTO bbc VALUES ('Japan', 'Asia');
</source>
<source lang='sql' class='def e-sqlite'>SELECT * FROM sqlite_master
WHERE type='table'
</source>
<source lang='sql' class='def e-db2'>SELECT * FROM syscat.tables
WHERE tabschema = 'SCOTT'
</source>
<source lang='sql' class='def e-ingres'>
</source>
<source lang='sql' class='def e-access'>SELECT Name FROM MSysObjects
WHERE Type=1 AND Flags=0
</source>
<source lang='sql' class='def e-postgres'>SELECT tablename FROM pg_tables
WHERE tableowner = current_user</source>
<source lang='sql' class='def e-oracle'>SELECT * FROM cat
</source>
<source lang='sql' class='def e-sqlserver'>SELECT * FROM sysobjects
WHERE xtype='U'
</source>
<source lang='sql' class='def e-mysql'>show tables
</source>
<source lang='sql' class='def e-mimer'>SELECT * FROM information_schema.tables
WHERE table_type='BASE TABLE'
</source>
<source lang='sql' class='def e-sybase'>SELECT * FROM sysobjects
WHERE type='U'</source>
<div class="ecomm e-sqlite" style="display: none">The table <code>sqlite_master</code> lists tables and indexes.</div>
<div class="ecomm e-db2" style="display: none">See SYSCAT.TABLES documentation.</div>
<div class="ecomm e-access" style="display: none">From within Access the system tables can be viewed by ticking the appropriate box under Tools/Options/View.</div>
<div class="ecomm e-oracle" style="display: none">See also user_tables and user_catalog.</div>
<div class="ecomm e-sqlserver" style="display: none">See also sp_table and table sysobjects.</div>
</div>
{{Meta_Data Ref}}

@@ Line 38: / Line 38: @@
 <div class="ecomm e-sqlserver" style="display: none">See also sp_table and table sysobjects.</div>
 </div>
-{{META DATA Ref}}
+{{Meta Data ref}}

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

@@ Line 8: / Line 8: @@
 <source lang=sql class='tidy'>
 </source>
 <source lang='sql' class='def e-sqlite'>SELECT * FROM sqlite_master
 WHERE type='table'

@@ Line 5: / Line 5: @@
 We should expect this to contain a great deal of extra data that is hard to understand.
 </div>
-<source lang=sql class='tidy'>CREATE TABLE bbc (name VARCHAR(10), region VARCHAR(10));
+<source lang=sql class='tidy'>
-INSERT INTO bbc VALUES ('Poland', 'Europe');
-INSERT INTO bbc VALUES ('Japan', 'Asia');
 </source>
 <source lang='sql' class='def e-sqlite'>SELECT * FROM sqlite_master