Portable SQL : Statements : Access metadata : Views

From Linuxnetworks

Contents 1 ANSI 2 Firebird/Interbase 3 MS SQL Server 4 MySQL 5 Oracle 6 PostgreSQL 7 SQLite 8 Sybase ASE

[edit] ANSI

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

SELECT table_name
FROM information_schema.views

[edit] Firebird/Interbase

SELECT DISTINCT RDB$VIEW_NAME
FROM RDB$VIEW_RELATIONS

[edit] MS SQL Server

SELECT name
FROM sys.views

[edit] MySQL

Fully compatible with SQL-92.

[edit] Oracle

SELECT view_name
FROM user_views

[edit] PostgreSQL

SELECT table_name
FROM information_schema.views
WHERE
 table_name !~ '^pg_' AND
 table_schema NOT IN ('pg_catalog', 'information_schema')

[edit] SQLite

Doesn't support retrieving views via an SQL statement.

[edit] Sybase ASE

EXEC sp_tables @table_type = "'VIEW'", @table_owner = "dbo"