-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathTable Columns.html
32 lines (27 loc) · 2.26 KB
/
Table Columns.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
<html>
<head>
<link rel="stylesheet" href="code_style.css">
</head>
<body>
<div class="code">
<span class="kwd">CREATE VIEW </span><span class="tab">service_meta_columns</span> <span class="kwl">AS</span><br />
<span class="kwd">WITH</span><br />
<div style="background-color: #F0E0F0">
<span class="tab">tables</span> <span class="kwl">AS (</span><br />
<span class="kwd">SELECT </span><span class="fld">tbl_name <span class="kwl">AS</span> table_name, sql</span><br />
<span class="kwd">FROM </span><span class="tab">sqlite_master</span><br />
<span class="kwd">WHERE </span><span class="fld">type</span> = <span class="lit">'table'</span><br />
<span class="kwl"> AND </span><span class="fld">name</span> <span class="kwl">NOT LIKE</span> <span class="lit">'sqlite_%'</span><br />
<span class="kwl">),</span><br />
</div>
<span class="tab">columns</span> <span class="kwl">AS (</span><br />
<span class="kwd">SELECT </span><span class="fld">table_name, cid, name<span class="kwl"> AS </span>col_name,</span><br />
<span class="fld"> type, "notnull", dflt_value, pk</span><br />
<span class="kwd">FROM </span><span class="tab">tables</span> <span class="kwl">AS</span> <span class="tab">t,</span><br />
<span class="prc"> pragma_table_xinfo</span>(<span class="tab">t</span><b>.</b><span class="fld">table_name</span>)<br />
<span class="kwd">ORDER BY </span><span class="fld">table_name, cid</span><br />
<span class="kwl">)</span><br />
<span class="kwd">SELECT <span class="fld">*</span> FROM </span><span class="tab">columns;</span><br />
</div>
</body>
</html>