{"id":14014,"date":"2021-09-20T10:43:51","date_gmt":"2021-09-20T08:43:51","guid":{"rendered":"https:\/\/dans.knaw.nl\/file-formats\/databases\/sql\/"},"modified":"2021-09-20T10:43:53","modified_gmt":"2021-09-20T08:43:53","slug":"sql","status":"publish","type":"page","link":"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/","title":{"rendered":"SQL"},"content":{"rendered":"<p>Many DBMSs support the ISO-standardized version of Structured Query Language (SQL): a language for querying and updating relational databases. Together with the Data Definition Language, used to define and modify schemas, the contents of a database can be stored as a collection of schema and data statements.<br \/>The language rarely changes, but the various modifications and additions may change along with software updates. If extensions are used, the documentation must show which SQL version is used.<br \/>It is possible to refer to non-existent and \/ or external data in SQL, without invalidating the file. If SQL is used for exchanging data, any external references must therefore be supplied, or each reference must be replaced by the data referred to.<\/p>\n<p>SQL is a preferred format for file type Databases.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Many DBMSs support the ISO-standardized version of Structured Query Language (SQL): a language for querying and updating relational databases. Together with the Data Definition Language, used to define and modify schemas, the contents of a database can be stored as a collection of schema and data statements.The language rarely changes, but the various modifications and [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"parent":13063,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","inline_featured_image":false,"footnotes":""},"class_list":["post-14014","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>File formats: SQL | DANS<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"File formats: SQL | DANS\" \/>\n<meta property=\"og:description\" content=\"Many DBMSs support the ISO-standardized version of Structured Query Language (SQL): a language for querying and updating relational databases. Together with the Data Definition Language, used to define and modify schemas, the contents of a database can be stored as a collection of schema and data statements.The language rarely changes, but the various modifications and [&hellip;]\" \/>\n<meta property=\"og:site_name\" content=\"DANS\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Data-Archiving-and-Networked-Services-DANS-140231255994524\/\" \/>\n<meta property=\"article:modified_time\" content=\"2021-09-20T08:43:53+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@dans_knaw_nwo\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/\",\"url\":\"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/\",\"name\":\"File formats: SQL | DANS\",\"isPartOf\":{\"@id\":\"https:\/\/dans.knaw.nl\/en\/#website\"},\"datePublished\":\"2021-09-20T08:43:51+00:00\",\"dateModified\":\"2021-09-20T08:43:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dans.knaw.nl\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"File formats\",\"item\":\"https:\/\/dans.knaw.nl\/en\/file-formats\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Databases\",\"item\":\"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dans.knaw.nl\/en\/#website\",\"url\":\"https:\/\/dans.knaw.nl\/en\/\",\"name\":\"DANS\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dans.knaw.nl\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"File formats: SQL | DANS","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/","og_locale":"en_US","og_type":"article","og_title":"File formats: SQL | DANS","og_description":"Many DBMSs support the ISO-standardized version of Structured Query Language (SQL): a language for querying and updating relational databases. Together with the Data Definition Language, used to define and modify schemas, the contents of a database can be stored as a collection of schema and data statements.The language rarely changes, but the various modifications and [&hellip;]","og_site_name":"DANS","article_publisher":"https:\/\/www.facebook.com\/Data-Archiving-and-Networked-Services-DANS-140231255994524\/","article_modified_time":"2021-09-20T08:43:53+00:00","twitter_card":"summary_large_image","twitter_site":"@dans_knaw_nwo","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/","url":"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/","name":"File formats: SQL | DANS","isPartOf":{"@id":"https:\/\/dans.knaw.nl\/en\/#website"},"datePublished":"2021-09-20T08:43:51+00:00","dateModified":"2021-09-20T08:43:53+00:00","breadcrumb":{"@id":"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dans.knaw.nl\/en\/"},{"@type":"ListItem","position":2,"name":"File formats","item":"https:\/\/dans.knaw.nl\/en\/file-formats\/"},{"@type":"ListItem","position":3,"name":"Databases","item":"https:\/\/dans.knaw.nl\/en\/file-formats\/databases\/"},{"@type":"ListItem","position":4,"name":"SQL"}]},{"@type":"WebSite","@id":"https:\/\/dans.knaw.nl\/en\/#website","url":"https:\/\/dans.knaw.nl\/en\/","name":"DANS","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dans.knaw.nl\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/pages\/14014","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/comments?post=14014"}],"version-history":[{"count":1,"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/pages\/14014\/revisions"}],"predecessor-version":[{"id":14015,"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/pages\/14014\/revisions\/14015"}],"up":[{"embeddable":true,"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/pages\/13063"}],"wp:attachment":[{"href":"https:\/\/dans.knaw.nl\/en\/wp-json\/wp\/v2\/media?parent=14014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}