http://www.thelinuxwiki.com/index.php?action=history&feed=atom&title=sqlite_query_table_names
sqlite query table names - Revision history
2026-04-29T05:03:13Z
Revision history for this page on the wiki
MediaWiki 1.21.5
http://www.thelinuxwiki.com/index.php?title=sqlite_query_table_names&diff=1255&oldid=prev
Nighthawk at 01:02, 15 May 2019
2019-05-15T01:02:17Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 01:02, 15 May 2019</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>use sqlite_master db</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>use sqlite_master db</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>  sqlite> select name from sqlite_master where name LIKE '<del class="diffchange diffchange-inline">use</del>%';</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>  sqlite> select name from sqlite_master where name LIKE '<ins class="diffchange diffchange-inline">string</ins>%';</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">where sting = text you looking for to start the table name and % = wildcard for remaining part of the name</ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[category:sqlite]]</div></td><td class='diff-marker'> </td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>[[category:sqlite]]</div></td></tr>
</table>
Nighthawk
http://www.thelinuxwiki.com/index.php?title=sqlite_query_table_names&diff=1254&oldid=prev
Nighthawk: Created page with "use sqlite_master db sqlite> select name from sqlite_master where name LIKE 'use%'; category:sqlite"
2019-05-15T01:00:57Z
<p>Created page with "use sqlite_master db sqlite> select name from sqlite_master where name LIKE 'use%'; <a href="/index.php?title=Category:sqlite&action=edit&redlink=1" class="new" title="Category:sqlite (page does not exist)">category:sqlite</a>"</p>
<p><b>New page</b></p><div>use sqlite_master db<br />
sqlite> select name from sqlite_master where name LIKE 'use%';<br />
[[category:sqlite]]</div>
Nighthawk