What are my tables?

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.

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'

The table sqlite_master lists tables and indexes.

See SYSCAT.TABLES documentation.

From within Access the system tables can be viewed by ticking the appropriate box under Tools/Options/View.

See also user_tables and user_catalog.

See also sp_table and table sysobjects.

Meta Data

What are my tables?

What are the columns of the BBC table?

Get the first 10 rows of the gisq.cia table.

Get the 11th to the 20th rows of the cia table - by population.

What version of the software am I using?

What is the syntax to view structure of table?

How can you determine the primary key using SQL?

Return a sequential record count for all records returned