{"id":6640,"date":"2022-03-05T06:11:00","date_gmt":"2022-03-05T05:11:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=6640"},"modified":"2022-11-10T11:12:05","modified_gmt":"2022-11-10T10:12:05","slug":"drop-database-script","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/","title":{"rendered":"Drop a SQL Server database with a script"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>How to delete a SQL Server database with a script?<\/em><\/strong><\/h4>\n\n\n\n<p>And delete all associated files? These files are the .mdf, .ndf, .ldf files and also the .bak backup files. Use the SQL Server Drop database command as below. With a check beforehand to avoid errors. It runs the command only if the SQL Server database exists on the given server and instance.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#create-a-sample-database-to-use-the-drop-query\" >Create a sample database to use the Drop query<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#script-to-drop-a-sql-server-database-on-all-versions\" >Script to drop a SQL Server database on all versions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#use-drop-database-if-exists-on-sql-server-2016-version-and-higher\" >Use Drop database If Exists on SQL Server 2016 version and higher<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"create-a-sample-database-to-use-the-drop-query\"><\/span>Create a sample database to use the Drop query<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here are two ways to create a new database, the first one is to <a href=\"https:\/\/expert-only.com\/en\/dba\/create-a-sql-server-database-with-a-script\/\">create the ms sql database with a script<\/a> or simply <a href=\"https:\/\/expert-only.com\/en\/sql-server-db\/create-a-database-with-sql-server-management-studio\/\">by using the SSMS graphic user interface<\/a>, abbreviated as GUI. Execute this first script to create an empty database to be dropped on the next steps. <\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE DATABASE MyDatabase;\nGO\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-script-to-drop-a-sql-server-database-on-all-versions\"><span class=\"ez-toc-section\" id=\"script-to-drop-a-sql-server-database-on-all-versions\"><\/span>Script to drop a SQL Server database on all versions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Hence, there are several ways to delete a database, either via the graphical interface of SSMS or via a simple SQL Server Drop database query as in this article. First of all, this sample code checks if the database exists on the server. Then the second part of the code deletes the database using the standard SQL Server <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/drop-database.html\" target=\"_blank\" rel=\"noreferrer noopener\">Drop database<\/a> database statement. <\/p>\n\n\n\n<p class=\"has-text-align-center\"><strong>Be careful, the following commands to delete the database is irreversible! Make sure you have the backups before running it<\/strong>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">USE MASTER;\nGO\n\nIF EXISTS (\n\tSELECT *\n\tFROM SYS.SYSDATABASES\n\tWHERE NAME='MyDatabase'\n)\nBEGIN\n\tDROP DATABASE MyDatabase;\nEND;\nGO\n<\/pre>\n\n\n\n<p>Note also another prerequisite for the SQL command to delete also the files physically on the disk, i.e. the <em>MDF<\/em> (master data file), <em>LDF<\/em> (log data file) and <em>BAK<\/em> (backup file) extensions. Indeed, to work, the database needs to be online at the time of the deletion. Finally, after running this command it is possible to check via Windows Explorer that the files have been deleted.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"use-drop-database-if-exists-on-sql-server-2016-version-and-higher\"><\/span>Use Drop database If Exists on SQL Server 2016 version and higher<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Starting from SQL Server 2016, it possible to check if the database, or any other droppable object, and drop it with one single line of code.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">USE MASTER;\nGO\n\nDROP DATABASE IF EXISTS MyDatabase;\nGO\n<\/pre>\n\n\n\n<p>To go further, sometimes the delete command does not work because the target database is in use. Here is how to manage the problem and avoid the 3702 error: <a href=\"https:\/\/expert-only.com\/en\/sql-server-db\/cannot-drop-the-database-because-it-is-currently-in-use\/\">Cannot drop the database because it is currently in use<\/a>.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">SQL Server Administration tutorials<\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/expert-only.com\/en\/sql-server-db\/install-a-second-instance-of-sql-server\/\">Tutorial to install a second instance of SQL Server.<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/dba\/create-a-sql-server-database-with-a-script\/\">How to create a SQL database with a script?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/expert-only.com\/en\/sql-server-db\/empty-the-sql-server-transaction-log-and-fix-error-9002\/\">How to empty the MS SQL transaction log and fix the 9002 error?<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>How to delete a SQL Server database with a script? And delete all associated files? These files are the .mdf, .ndf, .ldf files and also the .bak backup files. Use the SQL Server Drop database command as below. With <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/\" title=\"Drop a SQL Server database with a script\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5961,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[488],"tags":[630,417],"class_list":{"0":"post-6640","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-dba","8":"tag-drop","9":"tag-file"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Drop a SQL Server database with a script - MS SQL DBA<\/title>\n<meta name=\"description\" content=\"How to delete a SQL Server database with a script? The SQL drop database statement deletes the log files and backup files from the server.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Drop a SQL Server database with a script\" \/>\n<meta property=\"og:description\" content=\"How to delete a SQL Server database with a script? The SQL drop database statement deletes the log files and backup files from the server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-03-05T05:11:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-10T10:12:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Drop a SQL Server database with a script\",\"datePublished\":\"2022-03-05T05:11:00+00:00\",\"dateModified\":\"2022-11-10T10:12:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/\"},\"wordCount\":396,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg\",\"keywords\":[\"drop\",\"File\"],\"articleSection\":[\"SQL Server DBA\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/\",\"url\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/\",\"name\":\"Drop a SQL Server database with a script - MS SQL DBA\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg\",\"datePublished\":\"2022-03-05T05:11:00+00:00\",\"dateModified\":\"2022-11-10T10:12:05+00:00\",\"description\":\"How to delete a SQL Server database with a script? The SQL drop database statement deletes the log files and backup files from the server.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Drop a SQL Server database with a script\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Drop a SQL Server database with a script - MS SQL DBA","description":"How to delete a SQL Server database with a script? The SQL drop database statement deletes the log files and backup files from the server.","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:\/\/expert-only.com\/en\/dba\/drop-database-script\/","og_locale":"en_US","og_type":"article","og_title":"Drop a SQL Server database with a script","og_description":"How to delete a SQL Server database with a script? The SQL drop database statement deletes the log files and backup files from the server.","og_url":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-03-05T05:11:00+00:00","article_modified_time":"2022-11-10T10:12:05+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Drop a SQL Server database with a script","datePublished":"2022-03-05T05:11:00+00:00","dateModified":"2022-11-10T10:12:05+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/"},"wordCount":396,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg","keywords":["drop","File"],"articleSection":["SQL Server DBA"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/","url":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/","name":"Drop a SQL Server database with a script - MS SQL DBA","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg","datePublished":"2022-03-05T05:11:00+00:00","dateModified":"2022-11-10T10:12:05+00:00","description":"How to delete a SQL Server database with a script? The SQL drop database statement deletes the log files and backup files from the server.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/dba\/drop-database-script\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/dba\/drop-database-script\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"Drop a SQL Server database with a script"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=6640"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/6640\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5961"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=6640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=6640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=6640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}