{"id":2471,"date":"2014-07-09T19:00:58","date_gmt":"2014-07-09T23:00:58","guid":{"rendered":"http:\/\/sqlity.net\/en\/?p=2471"},"modified":"2014-11-13T13:36:20","modified_gmt":"2014-11-13T18:36:20","slug":"sys-dm_db_database_page_allocations","status":"publish","type":"post","link":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/","title":{"rendered":"The sys.dm_db_database_page_allocations DMF"},"content":{"rendered":"
\n

Finding the Pages of a Table in SQL Server 2012 and Later<\/h2>\n

Introduction<\/h3>\n

\nIn SQL Server versions before SQL Server 2012, you have to use the undocumented DBCC IND<\/span> command<\/a> if you want to know which pages belong to a particular table. Since version 2012, SQL Server provides a simpler (but still undocumented) method to get that information.\n<\/p>\n

The sys.dm_db_database_page_allocations DMF<\/h3>\n

\nThe sys.dm_db_database_page_allocations<\/span> DMF takes five parameters:\n<\/p>\n

\n[sql]\n\t@DatabaseId\t\t\tSMALLINT,
\n\t@TableId\t\t\tINT \t\t\t= NULL,
\n\t@IndexId \t\t\tINT \t\t\t= NULL,
\n\t@PartitionId\t\tBIGINT\t\t\t= NULL,
\n\t@Mode\t\t\t\tNVARCHAR(64)\t= 'LIMITED'
\n [\/sql]\n<\/div>\n

\nThe @DatabaseId<\/span>, @TableId<\/span>, @IndexId<\/span> and @PartitionId<\/span> detail the object whose pages you are interested in. @TableId<\/span>, @IndexId<\/span> and @PartitionId<\/span> can be NULL<\/span>, the @DatabaseId<\/span> has to be specified. If for example, you specify the @TableId<\/span> and @IndexId<\/span> of a particular index but you pass in NULL<\/span> for the @PartitionId<\/span>, the function will return all pages in all partitions for that particular index. If only the @DatabaseId<\/span> is valued, all (table related) pages in that database are returned.\n<\/p>\n

\nThe @Mode<\/span> can be either 'LIMITED'<\/span> or 'DETAILED'<\/span>. 'LIMITED'<\/span> returns less information. However, 'DETAILED'<\/span> uses significantly more resources. Therefore, it should be used only on small sets of pages.\n<\/p>\n

This DMF returns quite a few columns. The full list you can see in the following SELECT<\/span> statement:<\/p>\n

\n[sql]\nSELECT DDDPA.database_id,
\n DDDPA.object_id,
\n DDDPA.index_id,
\n DDDPA.partition_id,
\n DDDPA.rowset_id,
\n DDDPA.allocation_unit_id,
\n DDDPA.allocation_unit_type,
\n DDDPA.allocation_unit_type_desc,
\n DDDPA.data_clone_id,
\n DDDPA.clone_state,
\n DDDPA.clone_state_desc,
\n DDDPA.extent_file_id,
\n DDDPA.extent_page_id,
\n DDDPA.allocated_page_iam_file_id,
\n DDDPA.allocated_page_iam_page_id,
\n DDDPA.allocated_page_file_id,
\n DDDPA.allocated_page_page_id,
\n DDDPA.is_allocated,
\n DDDPA.is_iam_page,
\n DDDPA.is_mixed_page_allocation,
\n DDDPA.page_free_space_percent,
\n DDDPA.page_type,
\n DDDPA.page_type_desc,
\n DDDPA.page_level,
\n DDDPA.next_page_file_id,
\n DDDPA.next_page_page_id,
\n DDDPA.previous_page_file_id,
\n DDDPA.previous_page_page_id,
\n DDDPA.is_page_compressed,
\n DDDPA.has_ghost_records
\n FROM sys.dm_db_database_page_allocations
\n (
\n DB_ID(),
\n OBJECT_ID('dbo.tst'),
\n NULL,
\n NULL,
\n 'DETAILED'
\n ) AS DDDPA;
\n[\/sql]\n<\/div>\n

\nThe function returns one row per page that belongs to one of the partitions selected by the parameters.
\nThe columns database_id<\/span> to partition_id<\/span> specify the partition to which the page belongs. The three allocation unit columns reference the allocation unit of the page. The preceding rowset_id<\/span> column is what the sys.allocation_units<\/span> catalog view calls container_id<\/span>. The two extent columns identify the first page of the page's extent and the IAM columns tell us which IAM page has the current page cataloged. allocated_page_file_id<\/span> and allocated_page_page_id<\/span> contain the information we are really after here. They specify the file id and page number of the current page.\n<\/p>\n

\nAll the other columns give us more detailed information about the page itself, for example the page type or the level of the page within the index. Many of these additional columns are only valued when the @Mode<\/span> parameter is set to 'DETAILED'<\/span>.\n<\/p>\n

\nThe screenshot below shows a few of the column returned for one of my example tables:\n<\/p>\n

\n\"sys.dm_db_database_page_allocations<\/a>\n<\/p>\n<\/p>\n

Summary<\/h3>\n

\nSince SQL Server 2012, the sys.dm_db_database_page_allocations<\/span> DMF provides an easier to use alternative to the DBCC IND<\/span> command. It also provides a lot more information about each page than that DBCC<\/span> command. However, like DBCC IND<\/span>, the sys.dm_db_satabase_page_allocations<\/span> DMF is sadly not part of the official documentation, and as such its functionality cannot be guaranteed.\n<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Are you looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a particular table (or even all tables in a database).<\/p>\n

[more…]<\/a><\/p>\n","protected":false},"author":3,"featured_media":2472,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[5,27,24,14,105],"tags":[129,111,155,107,15,108,109],"class_list":["post-2471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-general","category-series","category-sql-server-2012","category-sql-server-internals","category-storage-wednesday","tag-dbcc-ind","tag-dbcc-page","tag-iam-page","tag-page","tag-sql-server","tag-storage","tag-storage-engine"],"acf":[],"yoast_head":"\nThe sys.dm_db_database_page_allocations DMF - sqlity.net<\/title>\n<meta name=\"description\" content=\"Looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a table.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The sys.dm_db_database_page_allocations DMF - sqlity.net\" \/>\n<meta property=\"og:description\" content=\"Looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/\" \/>\n<meta property=\"og:site_name\" content=\"sqlity.net\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/sqlity.net\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-09T23:00:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-11-13T18:36:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/07\/sys.dm_db_database_page_allocations_in_action.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"468\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Sebastian Meine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@sqlity\" \/>\n<meta name=\"twitter:site\" content=\"@sqlity\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sebastian Meine\" \/>\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:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/\"},\"author\":{\"name\":\"Sebastian Meine\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"headline\":\"The sys.dm_db_database_page_allocations DMF\",\"datePublished\":\"2014-07-09T23:00:58+00:00\",\"dateModified\":\"2014-11-13T18:36:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/\"},\"wordCount\":679,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/sys.dm_db_database_page_allocations_in_action.jpg\",\"keywords\":[\"DBCC IND\",\"DBCC PAGE\",\"IAM page\",\"page\",\"SQL Server\",\"storage\",\"storage engine\"],\"articleSection\":[\"General\",\"Series\",\"SQL Server 2012\",\"SQL Server Internals\",\"Storage Wednesday\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/\",\"name\":\"The sys.dm_db_database_page_allocations DMF - sqlity.net\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/sys.dm_db_database_page_allocations_in_action.jpg\",\"datePublished\":\"2014-07-09T23:00:58+00:00\",\"dateModified\":\"2014-11-13T18:36:20+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\"},\"description\":\"Looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a table.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/sys.dm_db_database_page_allocations_in_action.jpg\",\"contentUrl\":\"https:\\\/\\\/sqlity.net\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/sys.dm_db_database_page_allocations_in_action.jpg\",\"width\":768,\"height\":468,\"caption\":\"sys.dm_db_database_page_allocations in action\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/2471\\\/sys-dm_db_database_page_allocations\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The sys.dm_db_database_page_allocations DMF\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/sqlity.net\\\/en\\\/\",\"name\":\"sqlity.net\",\"description\":\"Quality for SQL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sqlity.net\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sqlity.net\\\/en\\\/#\\\/schema\\\/person\\\/bcffd8c572bc2f1bd10fdba80135e53c\",\"name\":\"Sebastian Meine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g\",\"caption\":\"Sebastian Meine\"},\"sameAs\":[\"http:\\\/\\\/sqlity.net\",\"https:\\\/\\\/x.com\\\/sqlity\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The sys.dm_db_database_page_allocations DMF - sqlity.net","description":"Looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a table.","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:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/","og_locale":"en_US","og_type":"article","og_title":"The sys.dm_db_database_page_allocations DMF - sqlity.net","og_description":"Looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a table.","og_url":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/","og_site_name":"sqlity.net","article_publisher":"https:\/\/www.facebook.com\/sqlity.net","article_published_time":"2014-07-09T23:00:58+00:00","article_modified_time":"2014-11-13T18:36:20+00:00","og_image":[{"width":768,"height":468,"url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/07\/sys.dm_db_database_page_allocations_in_action.jpg","type":"image\/jpeg"}],"author":"Sebastian Meine","twitter_card":"summary_large_image","twitter_creator":"@sqlity","twitter_site":"@sqlity","twitter_misc":{"Written by":"Sebastian Meine","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/#article","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/"},"author":{"name":"Sebastian Meine","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"headline":"The sys.dm_db_database_page_allocations DMF","datePublished":"2014-07-09T23:00:58+00:00","dateModified":"2014-11-13T18:36:20+00:00","mainEntityOfPage":{"@id":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/"},"wordCount":679,"commentCount":1,"image":{"@id":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/07\/sys.dm_db_database_page_allocations_in_action.jpg","keywords":["DBCC IND","DBCC PAGE","IAM page","page","SQL Server","storage","storage engine"],"articleSection":["General","Series","SQL Server 2012","SQL Server Internals","Storage Wednesday"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/","url":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/","name":"The sys.dm_db_database_page_allocations DMF - sqlity.net","isPartOf":{"@id":"https:\/\/sqlity.net\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/#primaryimage"},"image":{"@id":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/#primaryimage"},"thumbnailUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/07\/sys.dm_db_database_page_allocations_in_action.jpg","datePublished":"2014-07-09T23:00:58+00:00","dateModified":"2014-11-13T18:36:20+00:00","author":{"@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c"},"description":"Looking for an alternative to DBCC IND? Read on to see how the new sys.dm_db_database_page_allocations DMF can be used to return all pages for a table.","breadcrumb":{"@id":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/#primaryimage","url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/07\/sys.dm_db_database_page_allocations_in_action.jpg","contentUrl":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/07\/sys.dm_db_database_page_allocations_in_action.jpg","width":768,"height":468,"caption":"sys.dm_db_database_page_allocations in action"},{"@type":"BreadcrumbList","@id":"https:\/\/sqlity.net\/en\/2471\/sys-dm_db_database_page_allocations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sqlity.net\/en\/"},{"@type":"ListItem","position":2,"name":"The sys.dm_db_database_page_allocations DMF"}]},{"@type":"WebSite","@id":"https:\/\/sqlity.net\/en\/#website","url":"https:\/\/sqlity.net\/en\/","name":"sqlity.net","description":"Quality for SQL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sqlity.net\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/sqlity.net\/en\/#\/schema\/person\/bcffd8c572bc2f1bd10fdba80135e53c","name":"Sebastian Meine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4ab0a6d02dd494849a584a2c3c8bc3bdcef1d0aa5f87e98bf905dbdb9ad2ce3a?s=96&d=mm&r=g","caption":"Sebastian Meine"},"sameAs":["http:\/\/sqlity.net","https:\/\/x.com\/sqlity"]}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2wXuw-DR","jetpack-related-posts":[],"jetpack_featured_media_url":"https:\/\/sqlity.net\/wp-content\/uploads\/2014\/07\/sys.dm_db_database_page_allocations_in_action.jpg","_links":{"self":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/2471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/comments?post=2471"}],"version-history":[{"count":0,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/posts\/2471\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media\/2472"}],"wp:attachment":[{"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/media?parent=2471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/categories?post=2471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlity.net\/en\/wp-json\/wp\/v2\/tags?post=2471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}