*** 1,21 ****
<html>
<H1>Information Schema</h1>
! <font face='Verdana'><a href='http://www.postgresql.org/docs/current/static/information-schema.html'>.</a><br>
! If you have question regarding this information or if I have something wrong please email me at vbsqliteNOSPAM@NOSPAMag-software.com (remove the NOSPAM's)<p>
! The information schema consists of a set of views that contain information about the objects defined in the current database. The information schema is defined in the SQL standard and can therefore be expected to be portable and remain stable.<p>
<b>SQLite_Master</b> is the base table where schema information is stored, these views query this table<p>
SQLite doesn't support the idea of different owners of objects so the naming convention for the INFORMATION_SCHEMA views are <br>INFORMATION_SCHEMA_<b>OBJECTNAME</b><p>
<br>
<b><font size=3>Information_Schema_TABLES</font></b><br>
The view TABLES contains all tables and views defined in the current database<p>
! <code><b>
! Create View INFORMATION_SCHEMA_TABLES as<br>
! Select * from (
! select 'main' as TABLE_CATALOG , 'sqlite' as TABLE_SCHEMA , tbl_name as TABLE_NAME , case when type = 'table' then 'BASE TABLE' when type = 'view' then 'VIEW' end as TABLE_TYPE, sql as TABLE_SOURCE from sqlite_master where type in('table','view') and tbl_name not like 'INFORMATION_SCHEMA_%'
! union
! select 'main' as TABLE_CATALOG , 'sqlite' as TABLE_SCHEMA , tbl_name as TABLE_NAME , case when type = 'table' then 'TEMPORARY TABLE' when type = 'view' then 'TEMPORARY VIEW' end as TABLE_TYPE, sql as TABLE_SOURCE from sqlite_temp_master where type in('table','view') and tbl_name not like 'INFORMATION_SCHEMA_%'
! ) BT order by TABLE_TYPE , TABLE_NAME</b></code><p>
<b>Columns Description</b><br>
<table border="1" cellspacing="0" cellpadding="0" >
<tr>
--- 1,41 ----
<html>
<H1>Information Schema</h1>
!
! <p>If you have question regarding this information or if I have something wrong please email me at vbsqliteNOSPAM@NOSPAMag-software.com (remove the NOSPAM's)<p>
! The information schema consists of a set of views that contain information about the objects defined in the current database. The information schema is defined in the SQL standard and can therefore be expected to be portable and remain stable.</p>
<b>SQLite_Master</b> is the base table where schema information is stored, these views query this table<p>
SQLite doesn't support the idea of different owners of objects so the naming convention for the INFORMATION_SCHEMA views are <br>INFORMATION_SCHEMA_<b>OBJECTNAME</b><p>
<br>
<b><font size=3>Information_Schema_TABLES</font></b><br>
The view TABLES contains all tables and views defined in the current database<p>
! <pre>
! CREATE VIEW INFORMATION_SCHEMA_TABLES AS
! SELECT * FROM (
! SELECT 'main' AS TABLE_CATALOG,
! 'sqlite' AS TABLE_SCHEMA,
! tbl_name AS TABLE_NAME,
! CASE WHEN type = 'table' THEN 'BASE TABLE'
! WHEN type = 'view' THEN 'VIEW'
! END AS TABLE_TYPE,
! sql AS TABLE_SOURCE
! FROM sqlite_master
! WHERE type IN ('table', 'view')
! AND tbl_name NOT LIKE 'INFORMATION_SCHEMA_%'
! UNION
! SELECT 'main' AS TABLE_CATALOG,
! 'sqlite' AS TABLE_SCHEMA,
! tbl_name AS TABLE_NAME,
! CASE WHEN type = 'table' THEN 'TEMPORARY TABLE'
! WHEN type = 'view' THEN 'TEMPORARY VIEW'
! END AS TABLE_TYPE,
! sql AS TABLE_SOURCE
! FROM sqlite_temp_master
! WHERE type IN ('table', 'view')
! AND tbl_name NOT LIKE 'INFORMATION_SCHEMA_%'
! ) ORDER BY TABLE_TYPE, TABLE_NAME;
! </pre>
!
<b>Columns Description</b><br>
<table border="1" cellspacing="0" cellpadding="0" >
<tr>
***************
*** 46,50 ****
<td>The SQL script with which the object was created.</td>
</tr>
</table>
! </font>
</html>
--- 66,71 ----
<td>The SQL script with which the object was created.</td>
</tr>
</table>
!
! <p>(Compare PostgreSQL's <a href='http://www.postgresql.org/docs/current/static/information-schema.html'>information schema documentation</a>.)</p>
</html>
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|