*** 5,11 **** 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 convension 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> --- 5,11 ---- 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>
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|