{"id":520,"date":"2024-03-12T20:45:15","date_gmt":"2024-03-12T20:45:15","guid":{"rendered":"https:\/\/datacrazyworld.com\/?p=520"},"modified":"2024-06-08T17:28:28","modified_gmt":"2024-06-08T17:28:28","slug":"documenta-facilmente-tus-bbdd","status":"publish","type":"post","link":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/","title":{"rendered":"Documenta f\u00e1cilmente tus BBDD"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Este ser\u00e1 el primero de una serie de art\u00edculos que, combin\u00e1ndolos entre ellos, podr\u00e1s obtener la documentaci\u00f3n de tu base de datos o incluso de tu modelo tabular de manera sencilla y autom\u00e1ticamente, en un simple clic.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En este primer art\u00edculo voy a abordar el c\u00f3mo documentar una base de datos de SQL Server, de forma que la informaci\u00f3n est\u00e9 contenida en la propia base de datos y pueda ser explotada por otras herramientas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Empezar\u00e9 hablando de las propiedades extendidas de los objetos de SQL Server.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfQu\u00e9 son?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Se trata de unas etiquetas del tipo \u201cClave \u2013 Valor\u201d que puedes asociar a cada uno de los objetos de la base de datos.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfPara qu\u00e9 sirven?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Para lo que t\u00fa quieras o necesites. Puedes usar para clasificar los objetos, a\u00f1adir descripciones, explicaciones, etc. Aportan la informaci\u00f3n adicional que tu quieras sobre el objeto al que est\u00e1n asociados.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00bfC\u00f3mo accedo a ellas?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Puedes acceder usando la interfaz: <em>btn derecho<\/em> &#8211;&gt;  <em>propiedades <\/em>&#8211;&gt; <em>propiedades extendidas<\/em>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"578\" src=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/03\/image-1024x578.png\" alt=\"\" class=\"wp-image-522\" srcset=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/03\/image-1024x578.png 1024w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/03\/image-300x169.png 300w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/03\/image-768x434.png 768w, https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/03\/image.png 1321w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Tambi\u00e9n puedes usar la dmv <em>sys.extended_properties<\/em> para consultarlas. Puedes encontrar toda la informaci\u00f3n sobre esta vista <a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/relational-databases\/system-catalog-views\/extended-properties-catalog-views-sys-extended-properties?view=sql-server-ver16\" title=\"\">aqu\u00ed<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ej: Obtener todas las tablas con su descripci\u00f3n si la tiene<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Select \n\tSCHEMA_NAME(schema_id) as &#91;SCHEMA]\n\t,t.&#91;name] as &#91;TABLE]\n\t,p.value as &#91;MS_Description]\nfrom sys.tables t\n\tleft join sys.extended_properties p\n\t\ton p.major_id = t.object_id and p.name ='MS_Description'\n\t\t\tand p.minor_id = 0\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Ej: Obtener todas las columnas con su descripci\u00f3n si la tienen (quitando las del esquema <em>sys<\/em>)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Select \n\tOBJECT_SCHEMA_NAME (object_id) as &#91;SCHEMA]\n\t,OBJECT_NAME (object_id) as &#91;TABLE]\n\t,c.name as &#91;COLUMN]\n\t,p.Value as &#91;MS_Description]\nfrom sys.columns c\n\t\t\tleft join sys.extended_properties p\n\t\t\t\ton p.major_id = c.object_id and c.column_id = p.minor_id\n\t\t\t\tand p.name ='MS_Description'\nWHERE OBJECT_SCHEMA_NAME (object_id) &lt;&gt; 'sys'\nORDER by 1,2,column_id<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">O puedes usar las funciones del sistema para interactuar con ellas:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>sp_addextendedproperty <\/strong>: Permite agregar una propiedad extendida a un objeto (<a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/relational-databases\/system-stored-procedures\/sp-addextendedproperty-transact-sql?view=sql-server-ver16\" title=\"\">ver<\/a>)<\/li>\n\n\n\n<li><strong>fn_listextendedproperty<\/strong>: Devuelve los valores de propiedad extendidas del objeto (<a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/relational-databases\/system-functions\/sys-fn-listextendedproperty-transact-sql?view=sql-server-ver16\" title=\"\">ver<\/a>)<\/li>\n\n\n\n<li><strong>sp_dropextendedproperty<\/strong>: Quita una propiedad extendida existente (<a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/relational-databases\/system-stored-procedures\/sp-dropextendedproperty-transact-sql?view=sql-server-ver16\" title=\"\">ver<\/a>)<\/li>\n\n\n\n<li><strong>sp_updateextendedproperty<\/strong>: Actualiza el valor de una propiedad extendida existente (<a href=\"https:\/\/learn.microsoft.com\/es-es\/sql\/relational-databases\/system-stored-procedures\/sp-updateextendedproperty-transact-sql?view=sql-server-ver16\" title=\"\">ver<\/a>)<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Ejemplos pr\u00e1cticos<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A parte de para incluir la descripci\u00f3n, que normalmente se utiliza la clave \u201c<em>MS_Description<\/em>\u201d para ello, yo lo he usado para indicar cosas como:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cu\u00e1l es el Alias de una tabla<\/li>\n\n\n\n<li>Cu\u00e1les son las columnas por las que se particiona una tabla<\/li>\n\n\n\n<li>El tipo de SCD (Slow Changing Dimension) de una columna<\/li>\n\n\n\n<li>Qu\u00e9 tablas son las tablas maestras (es decir, las que deber\u00edan tener valores si cre\u00e1ramos desde 0 la base de datos)<\/li>\n\n\n\n<li>\u2026<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Truquillo<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Para interactuar con las propiedades extendidas, yo he descubierto que es m\u00e1s c\u00f3modo informarlas en un Excel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/github.com\/DataCrazyWorld\/DataCrazyWorld\/blob\/main\/Posts\/Ejemplo%20Excel%20Gestion%20Docu%20BBDD.xlsx\" title=\"\">Aqu\u00ed os dejo un ejemplo<\/a> de c\u00f3mo suelo hacerlo ( igual hay una forma mejor de hacerlo, pero por ahora me arreglo bien con esta). En este ejemplo s\u00f3lo miro tablas y columnas, pero se podr\u00edan a\u00f1adir vistas, u otros objetos.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cuando os descargu\u00e9is el ejemplo, ver\u00e9is que tiene 6 pesta\u00f1as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Tablas<\/strong>: El listado de tablas con su esquema y por cada propiedad extendida una columna. Tambi\u00e9n incluye la \u201cQuery\u201d que habr\u00eda que lanzar en la base de datos correspondiente (en el ejemplo es AdventureWorks2022).<\/li>\n\n\n\n<li><strong>Documentaci\u00f3n tablas<\/strong>: Incluye una tabla que referencia a la pesta\u00f1a anterior y luego le a\u00f1ado las siguientes columnas:\n<ul class=\"wp-block-list\">\n<li><strong>Rename<\/strong>: si quiero cambiar el nombre de la tabla lo incluyo aqu\u00ed<\/li>\n\n\n\n<li><strong>Script Rename<\/strong>: construye el script para renombrar la tabla.<\/li>\n\n\n\n<li><strong>Script Description<\/strong>: construye el script para a\u00f1adir o actualizar la propiedad extendida de la tabla, usando los datos de la siguiente pesta\u00f1a (<em>Scripts Tablas<\/em>).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Cuando quiero cambiar una descripci\u00f3n, relleno \/ cambio la columna <em>MS_Description<\/em> y luego s\u00f3lo tengo que ejecutar todos los scripts en la BBDD y listo.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Scripts Tabla<\/strong>: Aqu\u00ed incluyo en cada celda el script que quiero que se genere, mediante f\u00f3rmulas de Excel. Por cada propiedad extendida diferente, tendr\u00eda que generar el script que necesite.<\/li>\n\n\n\n<li><strong>Columnas<\/strong>: El listado de columnas, con su respectiva tabla y descripci\u00f3n. Adem\u00e1s, tambi\u00e9n incluyo el quiere que genera este listado.<\/li>\n\n\n\n<li><strong>Documentaci\u00f3n columnas<\/strong>: al igual que con las tablas, referencio la tabla que hay en la pesta\u00f1a de columnas y luego a\u00f1ado las siguientes columnas:\n<ul class=\"wp-block-list\">\n<li><strong>Renamed Table<\/strong>: Por si se ha renombrado la tabla (para poder construir los scripts bien)<\/li>\n\n\n\n<li><strong>Renamed column<\/strong>: Por si quiero renombrar la columna.<\/li>\n\n\n\n<li><strong>Table2<\/strong>: (Campo oculto) Si se ha renombrado la tabla, se informa ese, sino el original. Lo utilizo para construir de forma m\u00e1s sencilla las f\u00f3rmulas en el Excel.<\/li>\n\n\n\n<li><strong>Column2<\/strong>: (Campo oculto) Si se ha renombrado la columna, se informa ese, sino el original. Lo utilizo para construir de forma m\u00e1s sencilla las f\u00f3rmulas en el Excel.<\/li>\n\n\n\n<li><strong>IsView<\/strong>: Para indicar si es una vista o una tabla, ya que necesito saberlo a la hora de construir los otros scripts. Aqu\u00ed yo parto del hecho de que en mis bases de datos si es una vista, lleva \u201cView\u201d en el nombre.<\/li>\n\n\n\n<li><strong>Script Rename<\/strong>: Si rellenas el renombrado de columna, se informar\u00e1<\/li>\n\n\n\n<li><strong>Script Description<\/strong>: construye el script para a\u00f1adir o actualizar la propiedad extendida de la columna, usando los datos de la siguiente pesta\u00f1a (<em>Scripts Columnas<\/em>).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Cuando quiero cambiar una descripci\u00f3n, relleno \/ cambio la columna <em>MS_Description<\/em> y luego s\u00f3lo tengo que ejecutar todos los scripts en la BBDD y listo.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Script Columnas<\/strong>: Aqu\u00ed incluyo en cada celda el script que quiero que se genere, mediante f\u00f3rmulas de Excel. Por cada propiedad extendida diferente, tendr\u00eda que generar el script que necesite.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusi\u00f3n<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Como ves, las propiedades extendidas son sencillas de utilizar y pueden a\u00f1adir mucho valor a tu base de datos, y adem\u00e1s puedes apoyarte en herramientas externas, como el Excel, para facilitarte mucho la vida. \u00a1No las desaproveches!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1er post sobre documentaci\u00f3n. \u00a1No te pierdas ninguno que combin\u00e1ndolos todos podr\u00e1s hacer milagros!<\/p>\n","protected":false},"author":2,"featured_media":525,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,10,9],"tags":[21,13,12],"class_list":["post-520","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqlserver","category-ssms","category-tsql","tag-sqlserver","tag-ssms","tag-tsql"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"1er post sobre documentaci\u00f3n. \u00a1No te pierdas ninguno que combin\u00e1ndolos todos podr\u00e1s hacer milagros!\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Cristina Tarabini-Castellani Ciordia\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@DataCrazyWorld\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Documenta f\u00e1cilmente tus BBDD - Data Crazy World\" \/>\n\t\t<meta name=\"twitter:description\" content=\"1er post sobre documentaci\u00f3n. \u00a1No te pierdas ninguno que combin\u00e1ndolos todos podr\u00e1s hacer milagros!\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@DataCrazyWorld\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2022\/12\/Color_Small.png\" \/>\n\t\t<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t\t<meta name=\"twitter:data1\" content=\"Cristina Tarabini-Castellani Ciordia\" \/>\n\t\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura estimado\" \/>\n\t\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#blogposting\",\"name\":\"Documenta f\\u00e1cilmente tus BBDD - Data Crazy World\",\"headline\":\"Documenta f\\u00e1cilmente tus BBDD\",\"author\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/CrazyDocu.png\",\"width\":1200,\"height\":630},\"datePublished\":\"2024-03-12T20:45:15+00:00\",\"dateModified\":\"2024-06-08T17:28:28+00:00\",\"inLanguage\":\"es-ES\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#webpage\"},\"articleSection\":\"SQL Server, SSMS, tsql, sqlserver, ssms, tsql\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com#listItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\\\/\\\/datacrazyworld.com\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/#listItem\",\"position\":2,\"name\":\"SQL Server\",\"item\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/tsql\\\/#listItem\",\"name\":\"tsql\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com#listItem\",\"name\":\"Inicio\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/tsql\\\/#listItem\",\"position\":3,\"name\":\"tsql\",\"item\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/tsql\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#listItem\",\"name\":\"Documenta f\\u00e1cilmente tus BBDD\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/#listItem\",\"name\":\"SQL Server\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#listItem\",\"position\":4,\"name\":\"Documenta f\\u00e1cilmente tus BBDD\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/category\\\/sqlserver\\\/tsql\\\/#listItem\",\"name\":\"tsql\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\",\"name\":\"Cristina Tarabini-Castellani Ciordia\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Cristina Tarabini-Castellani Ciordia\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/DataCrazyWorld\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/cristina-tarabini-castellani\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/\",\"name\":\"Cristina Tarabini-Castellani Ciordia\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Cristina Tarabini-Castellani Ciordia\"},\"sameAs\":[\"https:\\\/\\\/twitter.com\\\/DataCrazyWorld\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/cristina-tarabini-castellani\\\/\"]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#webpage\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/\",\"name\":\"Documenta f\\u00e1cilmente tus BBDD - Data Crazy World\",\"description\":\"1er post sobre documentaci\\u00f3n. \\u00a1No te pierdas ninguno que combin\\u00e1ndolos todos podr\\u00e1s hacer milagros!\",\"inLanguage\":\"es-ES\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/author\\\/tarabiquetevi\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/CrazyDocu.png\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#mainImage\",\"width\":1200,\"height\":630},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/index.php\\\/2024\\\/03\\\/12\\\/documenta-facilmente-tus-bbdd\\\/#mainImage\"},\"datePublished\":\"2024-03-12T20:45:15+00:00\",\"dateModified\":\"2024-06-08T17:28:28+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#website\",\"url\":\"https:\\\/\\\/datacrazyworld.com\\\/\",\"name\":\"DataCrazyWorld\",\"description\":\"SQL Server, PowerShell, Power BI, Power Platform,... Los datos, ese mundo tan interesante, variado, divertido y ... \\u00a1Loco!\",\"inLanguage\":\"es-ES\",\"publisher\":{\"@id\":\"https:\\\/\\\/datacrazyworld.com\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Documenta f\u00e1cilmente tus BBDD - Data Crazy World","description":"1er post sobre documentaci\u00f3n. \u00a1No te pierdas ninguno que combin\u00e1ndolos todos podr\u00e1s hacer milagros!","canonical_url":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#blogposting","name":"Documenta f\u00e1cilmente tus BBDD - Data Crazy World","headline":"Documenta f\u00e1cilmente tus BBDD","author":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"publisher":{"@id":"https:\/\/datacrazyworld.com\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/03\/CrazyDocu.png","width":1200,"height":630},"datePublished":"2024-03-12T20:45:15+00:00","dateModified":"2024-06-08T17:28:28+00:00","inLanguage":"es-ES","mainEntityOfPage":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#webpage"},"isPartOf":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#webpage"},"articleSection":"SQL Server, SSMS, tsql, sqlserver, ssms, tsql"},{"@type":"BreadcrumbList","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com#listItem","position":1,"name":"Inicio","item":"https:\/\/datacrazyworld.com","nextItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/#listItem","position":2,"name":"SQL Server","item":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/","nextItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/#listItem","name":"tsql"},"previousItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com#listItem","name":"Inicio"}},{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/#listItem","position":3,"name":"tsql","item":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/","nextItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#listItem","name":"Documenta f\u00e1cilmente tus BBDD"},"previousItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/#listItem","name":"SQL Server"}},{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#listItem","position":4,"name":"Documenta f\u00e1cilmente tus BBDD","previousItem":{"@type":"ListItem","@id":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/#listItem","name":"tsql"}}]},{"@type":"Person","@id":"https:\/\/datacrazyworld.com\/#person","name":"Cristina Tarabini-Castellani Ciordia","image":{"@type":"ImageObject","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g","width":96,"height":96,"caption":"Cristina Tarabini-Castellani Ciordia"},"sameAs":["https:\/\/twitter.com\/DataCrazyWorld","https:\/\/www.linkedin.com\/in\/cristina-tarabini-castellani\/"]},{"@type":"Person","@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author","url":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/","name":"Cristina Tarabini-Castellani Ciordia","image":{"@type":"ImageObject","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/020df7a271c91fd52178caf747ffe0997d2f1113e00f58e77a2878622e27453f?s=96&d=mm&r=g","width":96,"height":96,"caption":"Cristina Tarabini-Castellani Ciordia"},"sameAs":["https:\/\/twitter.com\/DataCrazyWorld","https:\/\/www.linkedin.com\/in\/cristina-tarabini-castellani\/"]},{"@type":"WebPage","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#webpage","url":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/","name":"Documenta f\u00e1cilmente tus BBDD - Data Crazy World","description":"1er post sobre documentaci\u00f3n. \u00a1No te pierdas ninguno que combin\u00e1ndolos todos podr\u00e1s hacer milagros!","inLanguage":"es-ES","isPartOf":{"@id":"https:\/\/datacrazyworld.com\/#website"},"breadcrumb":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#breadcrumblist"},"author":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"creator":{"@id":"https:\/\/datacrazyworld.com\/index.php\/author\/tarabiquetevi\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2024\/03\/CrazyDocu.png","@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#mainImage","width":1200,"height":630},"primaryImageOfPage":{"@id":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/#mainImage"},"datePublished":"2024-03-12T20:45:15+00:00","dateModified":"2024-06-08T17:28:28+00:00"},{"@type":"WebSite","@id":"https:\/\/datacrazyworld.com\/#website","url":"https:\/\/datacrazyworld.com\/","name":"DataCrazyWorld","description":"SQL Server, PowerShell, Power BI, Power Platform,... Los datos, ese mundo tan interesante, variado, divertido y ... \u00a1Loco!","inLanguage":"es-ES","publisher":{"@id":"https:\/\/datacrazyworld.com\/#person"}}]},"twitter:card":"summary_large_image","twitter:site":"@DataCrazyWorld","twitter:title":"Documenta f\u00e1cilmente tus BBDD - Data Crazy World","twitter:description":"1er post sobre documentaci\u00f3n. \u00a1No te pierdas ninguno que combin\u00e1ndolos todos podr\u00e1s hacer milagros!","twitter:creator":"@DataCrazyWorld","twitter:image":"https:\/\/datacrazyworld.com\/wp-content\/uploads\/2022\/12\/Color_Small.png","twitter:label1":"Escrito por","twitter:data1":"Cristina Tarabini-Castellani Ciordia","twitter:label2":"Tiempo de lectura estimado","twitter:data2":"5 minutos"},"aioseo_meta_data":{"post_id":"520","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2024-03-12 19:45:37","updated":"2025-06-04 03:42:51","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/datacrazyworld.com\" title=\"Inicio\">Inicio<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/\" title=\"SQL Server\">SQL Server<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/\" title=\"tsql\">tsql<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tDocumenta f\u00e1cilmente tus BBDD\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Inicio","link":"https:\/\/datacrazyworld.com"},{"label":"SQL Server","link":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/"},{"label":"tsql","link":"https:\/\/datacrazyworld.com\/index.php\/category\/sqlserver\/tsql\/"},{"label":"Documenta f\u00e1cilmente tus BBDD","link":"https:\/\/datacrazyworld.com\/index.php\/2024\/03\/12\/documenta-facilmente-tus-bbdd\/"}],"_links":{"self":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/comments?post=520"}],"version-history":[{"count":8,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/520\/revisions"}],"predecessor-version":[{"id":565,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/posts\/520\/revisions\/565"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/media\/525"}],"wp:attachment":[{"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/media?parent=520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/categories?post=520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datacrazyworld.com\/index.php\/wp-json\/wp\/v2\/tags?post=520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}