Portable SQL/Statements/Access metadata/Tables - Revision history

Nose: /* ANSI */

2008-05-07T09:46:45Z

‎ANSI

Nose: /* ANSI */

2008-05-07T09:30:38Z

‎ANSI

Nose: /* ANSI */

2008-05-07T09:30:10Z

‎ANSI

Nose: initial

2008-05-03T11:18:53Z

initial

New page

== ANSI ==

SQL-92 defines a collection of objects in INFORMATION_SCHEMA which contains the list of available tables:

SELECT table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'

== Firebird/Interbase ==

SELECT RDB$RELATION_NAME
FROM RDB$RELATIONS
WHERE
RDB$SYSTEM_FLAG=0 AND
RDB$VIEW_BLR IS NULL

== MS SQL Server ==

SELECT TableName
FROM information_schema.tables
WHERE
table_type = 'BASE TABLE' AND
OBJECTPROPERTY(OBJECT_ID(TableName), 'IsMsShipped') = 0
ORDER BY TableName

== MySQL ==

Fully compatible with SQL-92.

== Oracle ==

SELECT table_name
FROM user_tables

== PostgreSQL ==

SELECT table_name
FROM information_schema.tables
WHERE
table_type = 'BASE TABLE' AND
table_schema NOT IN ('pg_catalog', 'information_schema')

== SQLite ==

Doesn't support retrieving tables via an SQL statement.

== Sybase ASE ==

EXEC sp_tables @table_type = "'TABLE'"

@@ Line 8: / Line 8: @@
    table_type = 'BASE TABLE' AND
    table_schema = ''dbname''
 == Firebird/Interbase ==

@@ Line 5: / Line 5: @@
   SELECT table_name
   FROM information_schema.tables
-  WHERE table_type = 'BASE TABLE'
+  WHERE
 == Firebird/Interbase ==