{"id":9,"date":"2012-05-09T18:16:51","date_gmt":"2012-05-09T18:16:51","guid":{"rendered":"https:\/\/danielribes.com\/blog\/?p=4"},"modified":"2026-04-06T11:51:47","modified_gmt":"2026-04-06T11:51:47","slug":"sqlite-acceder-a-la-estructura-de-la-base-de-datos","status":"publish","type":"post","link":"https:\/\/danielribes.com\/blog\/sqlite-acceder-a-la-estructura-de-la-base-de-datos\/","title":{"rendered":"SQLITE: Acceder a la estructura de la base de datos"},"content":{"rendered":"<p>Si deseamos conocer la estructura de una base de datos SQLite tan solo tenemos que hacer un SELECT a la tabla <strong>sqlite_master.<\/strong><\/p>\n<p>Esta tabla es una tabla especial de SQLite que conserva la estructura de todo el fichero de la base de datos, por lo tanto nos informa de todas las tablas que contiene y sus respectivos campos.<\/p>\n<p>Por ejemplo, para volcar la informaci\u00f3n:<\/p>\n<pre>SELECT * FROM sqlite_master<\/pre>\n<p>Y para ver la definici\u00f3n (en formato SQL) de la tablas, realizamos una consulta sobre el campo <em>sql<\/em> del tipo <em>table<\/em> con:<\/p>\n<pre>SELECT sql FROM sqlite_master WHERE type='table'<\/pre>\n<p>M\u00e1s informaci\u00f3n en: <a href=\"http:\/\/www.sqlite.org\/faq.html#q7\">http:\/\/www.sqlite.org\/faq.html#q7<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Si deseamos conocer la estructura de una base de datos SQLite tan solo tenemos que hacer un SELECT a la tabla sqlite_master. Esta tabla es una tabla especial de SQLite que conserva la estructura de todo el fichero de la base de datos, por lo tanto nos informa de todas las tablas que contiene y [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[115],"tags":[92,22],"class_list":["post-9","post","type-post","status-publish","format-standard","hentry","category-desarrollo","tag-bases-de-datos","tag-sqlite"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":8}},"_links":{"self":[{"href":"https:\/\/danielribes.com\/blog\/wp-json\/wp\/v2\/posts\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/danielribes.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/danielribes.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/danielribes.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/danielribes.com\/blog\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":1,"href":"https:\/\/danielribes.com\/blog\/wp-json\/wp\/v2\/posts\/9\/revisions"}],"predecessor-version":[{"id":87,"href":"https:\/\/danielribes.com\/blog\/wp-json\/wp\/v2\/posts\/9\/revisions\/87"}],"wp:attachment":[{"href":"https:\/\/danielribes.com\/blog\/wp-json\/wp\/v2\/media?parent=9"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/danielribes.com\/blog\/wp-json\/wp\/v2\/categories?post=9"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/danielribes.com\/blog\/wp-json\/wp\/v2\/tags?post=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}