https://www.dbpilot.io/_app/immutable/chunks/CtKaU_m2.js

1import"./CWj6FrbW.js";import"./69_IOA4Y.js";import{s as p,f as d,c as t,r as e,b as c}from"./BZ3wHDxR.js";import{t as i,a as m}from"./B0yhBc00.js";import{h}from"./CY_rZqSt.js";const g={title:"How to view a table's CREATE TABLE statement in SQLite",date:"2023-07-09",updatedAt:"2023-07-09",category:"Basics",headings:[]},{title:_,date:f,updatedAt:E,category:k,headings:j}=g;var v=i('<p>Get the <code>CREATE TABLE</code> statement of an existing table called <code>my_table</code>:</p> <div class="code-block -mt-[1em] relative"><pre class="!mb-0 border border-gray-200 bg-white !p-0 not-prose"><code class="hljs rounded-lg !px-4 !py-[1.1rem] text-gray-900 text-sm not-prose"><!></code></pre><button type="button" class="copy-code-button absolute top-0 right-0 self-start hover:text-gray-900 p-1.5 rounded-md text-gray-600"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 24 24" stroke-width="1.5" stroke="currentColor" class="w-5 h-5"><path stroke-linecap="round" stroke-linejoin="round" d="M15.666 3.888A2.25 2.25 0 0013.5 2.25h-3c-1.03 0-1.9.693-2.166 1.638m7.332 0c.055.194.084.4.084.612v0a.75.75 0 01-.75.75H9a.75.75 0 01-.75-.75v0c0-.212.03-.418.084-.612m7.332 0c.646.049 1.288.11 1.927.184 1.1.128 1.907 1.077 1.907 2.185V19.5a2.25 2.25 0 01-2.25 2.25H6.75A2.25 2.25 0 014.5 19.5V6.257c0-1.108.806-2.057 1.907-2.185a48.208 48.208 0 011.927-.184"></path></svg><span class="sr-only">Copy code</span></button></div>',1);function A(n){var s=v(),a=p(d(s),2),o=t(a),r=t(o),l=t(r);h(l,()=>'<span class="hljs-keyword">SELECT</span> <span class="hljs-keyword">sql</span> <span class="hljs-keyword">FROM</span> sqlite_master <span class="hljs-keyword">WHERE</span> name <span class="hljs-operator">=</span> <span class="hljs-string">&#x27;my_table&#x27;</span>;'),e(r),e(o),c(),e(a),m(n,s)}export{A as default,g as metadata};