{"id":8481,"date":"2022-07-04T11:36:24","date_gmt":"2022-07-04T09:36:24","guid":{"rendered":"https:\/\/expert-only.com\/?p=8481"},"modified":"2022-07-11T15:49:42","modified_gmt":"2022-07-11T13:49:42","slug":"gestionar-las-tablas-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/","title":{"rendered":"Gestionar las tablas SQL Server"},"content":{"rendered":"\n

\u00bfC\u00f3mo gestionar las tablas de SQL Server? Aqu\u00ed hay una lista de sintaxis para las tablas de SQL Server. Las tablas SQL en general son el tipo de objeto m\u00e1s central que existe en una base de datos. Como un archivo es el bloque de construcci\u00f3n b\u00e1sico de cualquier sistema operativo. Mantenga esto como un marcador para crear una tabla f\u00e1cilmente.<\/p>\n\n\n\n

Gestionar las tablas SQL Server con scripts T-SQL<\/h2>\n\n\n\n

Aqu\u00ed se explica c\u00f3mo modificar una tabla o sus columnas con alter table y alter column.<\/p>\n\n\n\n

Pero tambi\u00e9n, c\u00f3mo vaciar una tabla con truncate table o eliminarla con drop table. Por \u00faltimo, comprueba la existencia de una tabla con la funci\u00f3n IF EXISTS antes de eliminarla de la base de datos de SQL Server.<\/p>\n\n\n\n

Ejemplo T-SQL para crear una tabla SQL Server<\/h3>\n\n\n\n

Este script de ejemplo utiliza el comando CREATE TABLE para crear una tabla de ventas. El script utiliza columnas para almacenar la hora a nivel de mes, el n\u00famero de empleado y los importes de las ventas.<\/p>\n\n\n\n

Esta tabla utiliza varios tipos de datos para mostrar una gama de formatos disponibles con SQL<\/a> Server. Sin embargo, tambi\u00e9n es razonable calcular los importes sobre la marcha con el valor del IVA almacenado una vez en otra tabla, por ejemplo con el a\u00f1o.<\/p>\n\n\n\n

-- Crear la tabla de ventas\nCREATE TABLE [dbo].[SALES] \n(\n[Year] INT, \n[MonthName] NVARCHAR(50), -- alphanumeric\n[MonthCurrent] BIT, -- Boolean, 0 or 1 , false \/ true\n[NumberMonth] TINYINT, -- very small integer, from 0 to 255\n[EmployeeNumber] SMALLINT, -- small integer, minimum -2^15, maximum 2^15\n[NumberOfClients] INTEGER, -- integer, minimum -2^31, maximum 2^31\n[NumberOfSales] BIGINT, -- big integer, minimum: -2^63, maximum 2^63\n[Amount_ET] NUMERIC(15,5), -- numeric, 15 digits, with 5 after the comma \n[Amount_IT] DECIMAL(15,5) -- decimal, 15 digits, with 5 after the comma\n);\n\n-- Notas:\n-- Amount_ET significa \"Amount Excluding Taxes\" (importe sin impuestos)\n-- Amount_IT significa Importe con impuestos incluidos\n-- Inserte tres filas en la tabla de ventas\nINSERT INTO [dbo].[SALES] VALUES ('Enero', 0,1,10,20,12,1000,1200);\nINSERT INTO [dbo].[SALES] VALUES ('Febrero', 0,1,10,20,12,1000,1200);\nINSERT INTO [dbo].[SALES] VALUES ('Marzo', 0,1,10,20,12,1000,1200);\n<\/pre>\n\n\n\n
Ejemplo de script para modificar una tabla (ALTER TABLE)<\/h3>\n\n\n\n
En primer lugar, para modificar una tabla y a\u00f1adir restricciones para controlar la integridad de los datos introducidos, utilice los comandos ALTER TABLE y ADD CONSTRAINT.<\/p>\n\n\n\n
A\u00f1ada una restricci\u00f3n en la tabla Ventas para comprobar que la columna nombre del mes no es nula.<\/p>\n\n\n\n
ALTER TABLE [dbo].[SALES] WITH CHECK\n   ADD CONSTRAINT Month_check CHECK (MonthName IS NOT NULL);\nGO\n<\/pre>\n\n\n\n
Ahora es posible insertar s\u00f3lo valores distintos de cero en la tabla de ventas.<\/p>\n\n\n\n
INSERT INTO [dbo].[SALES] VALUES (null, 0,1,10,20,12,1000,1200);\n<\/pre>\n\n\n\n
Si el valor del mes es nulo, aparece este error de SQL Server:<\/p>\n\n\n\n
La sentencia INSERT entr\u00f3 en conflicto con la restricci\u00f3n CHECK \u00abMonth_check\u00bb.
El conflicto se produjo en la base de datos \u00abExpert-Only\u00bb, tabla \u00abdbo.SALES\u00bb, columna ‘MonthName’.<\/p>\n\n\n\n
A\u00f1adir una columna a una tabla SQL (ALTER COLUMN)<\/h3>\n\n\n\n
En segundo lugar, para evolucionar una tabla, adapte este ejemplo para cambiar la longitud de las columnas con un script ALTER COLUMN.<\/p>\n\n\n\n
-- Change the length from 20 to 100 characters\nALTER TABLE [dbo].[SALES]\n\tALTER COLUMN [MonthName] NVARCHAR(100);\nGO\n<\/pre>\n\n\n\n
Eliminaci\u00f3n de datos de una tabla de SQL Server (DELETE FROM)<\/h3>\n\n\n\n
En tercer lugar, para eliminar datos con un filtro, utilice este script y ad\u00e1ptelo a las necesidades del proyecto. Este script borra los datos de los tres primeros meses, enero, febrero y marzo.<\/p>\n\n\n\n
DELETE FROM [dbo].[SALES]\n\tWHERE MonthName in ('Enero', 'Febrero', 'Marzo');\n<\/pre>\n\n\n\n
Vaciar todos los datos de una tabla de SQL Server (TRUNCATE TABLE)<\/h3>\n\n\n\n
Para vaciar todos los datos de una tabla de SQL Server sin ning\u00fan filtro, utilice el script TRUNCATE TABLE.<\/p>\n\n\n\n
TRUNCATE TABLE [dbo].[SALES];<\/pre>\n\n\n\n
Eliminar una tabla de MS SQL (DROP TABLE)<\/h3>\n\n\n\n
Utilice este comando T-SQL para eliminar una tabla de SQL Server, es decir, el contenido y la estructura de la tabla.<\/p>\n\n\n\n
DROP TABLE [dbo].[SALES];\n<\/pre>\n\n\n\n
Comprobar si una tabla existe y eliminarla (IF EXISTS y DROP TABLE)<\/h3>\n\n\n\n
Este \u00faltimo script es como un simple truncamiento pero comprueba adem\u00e1s si la tabla existe. Esto es para evitar errores de SQL Server como \u00abNo se puede encontrar el objeto porque no existe\u00bb.<\/p>\n\n\n\n
IF EXISTS (\n  SELECT 1 FROM sys.objects\n    WHERE  object_id = object_id(N'[dbo].[SALES]')\n    AND type in (N'U')  )\nBEGIN \n  DROP TABLE [dbo].[SALES]\nEND;\n<\/pre>\n\n\n\n
Por \u00faltimo, este art\u00edculo, que recomiendo guardar como favorito y compartir, recuerda las sintaxis b\u00e1sicas sobre las tablas de SQL Server. Como crear, modificar, volcar y eliminar.<\/p>\n\n\n\n
Adem\u00e1s, no se enumeran aqu\u00ed los detalles de cada operaci\u00f3n, porque el objetivo es tener la sintaxis a mano lo m\u00e1s r\u00e1pidamente posible.<\/p>\n\n\n\n
Aqu\u00ed hay otro art\u00edculo sobre T-SQL para calcular la diferencia entre fechas con SQL Server<\/a><\/strong> en horas, minutos y segundos.<\/p>\n\n\n\n
\nhttps:\/\/expert-only.com\/es\/t-sql\/diferencia-fechas-sql-server-horas-minutos-segundos\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"
\u00bfC\u00f3mo gestionar las tablas de SQL Server? Aqu\u00ed hay una lista de sintaxis para las tablas de SQL Server. Las tablas SQL en general son el tipo de objeto m\u00e1s central que existe en una base de datos. Como …<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":6050,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[455],"tags":[625,629,631],"class_list":{"0":"post-8481","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql","8":"tag-alter","9":"tag-create-es","10":"tag-drop"},"yoast_head":"\nGestionar las tablas SQL Server - T-SQL<\/title>\n<meta name=\"description\" content=\"Gestionar las tablas SQL Server con consultas T-SQL de ejemplo para crear, modificar, eliminar o volcar el contenido de las tablas.\" \/>\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\/es\/t-sql\/gestionar-las-tablas-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gestionar las tablas SQL Server\" \/>\n<meta property=\"og:description\" content=\"Gestionar las tablas SQL Server con consultas T-SQL de ejemplo para crear, modificar, eliminar o volcar el contenido de las tablas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriales de SQL y TI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-04T09:36:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-11T13:49:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/05\/desk-notes-pen-A4C6B252209_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=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Gestionar las tablas SQL Server\",\"datePublished\":\"2022-07-04T09:36:24+00:00\",\"dateModified\":\"2022-07-11T13:49:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/\"},\"wordCount\":609,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/05\/desk-notes-pen-A4C6B252209_1920x1080.jpeg\",\"keywords\":[\"Alter\",\"create\",\"drop\"],\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/\",\"name\":\"Gestionar las tablas SQL Server - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/05\/desk-notes-pen-A4C6B252209_1920x1080.jpeg\",\"datePublished\":\"2022-07-04T09:36:24+00:00\",\"dateModified\":\"2022-07-11T13:49:42+00:00\",\"description\":\"Gestionar las tablas SQL Server con consultas T-SQL de ejemplo para crear, modificar, eliminar o volcar el contenido de las tablas.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/05\/desk-notes-pen-A4C6B252209_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/05\/desk-notes-pen-A4C6B252209_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"es\",\"item\":\"https:\/\/expert-only.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Gestionar las tablas SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/es\/#website\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"name\":\"Tutoriales de SQL y TI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/es\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/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\/es\/#\/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\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/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":"Gestionar las tablas SQL Server - T-SQL","description":"Gestionar las tablas SQL Server con consultas T-SQL de ejemplo para crear, modificar, eliminar o volcar el contenido de las tablas.","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\/es\/t-sql\/gestionar-las-tablas-sql-server\/","og_locale":"es_ES","og_type":"article","og_title":"Gestionar las tablas SQL Server","og_description":"Gestionar las tablas SQL Server con consultas T-SQL de ejemplo para crear, modificar, eliminar o volcar el contenido de las tablas.","og_url":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/","og_site_name":"Tutoriales de SQL y TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-07-04T09:36:24+00:00","article_modified_time":"2022-07-11T13:49:42+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/05\/desk-notes-pen-A4C6B252209_1920x1080.jpeg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Escrito por":"Expert-Only","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Gestionar las tablas SQL Server","datePublished":"2022-07-04T09:36:24+00:00","dateModified":"2022-07-11T13:49:42+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/"},"wordCount":609,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/05\/desk-notes-pen-A4C6B252209_1920x1080.jpeg","keywords":["Alter","create","drop"],"articleSection":["T-SQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/","url":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/","name":"Gestionar las tablas SQL Server - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/05\/desk-notes-pen-A4C6B252209_1920x1080.jpeg","datePublished":"2022-07-04T09:36:24+00:00","dateModified":"2022-07-11T13:49:42+00:00","description":"Gestionar las tablas SQL Server con consultas T-SQL de ejemplo para crear, modificar, eliminar o volcar el contenido de las tablas.","breadcrumb":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/05\/desk-notes-pen-A4C6B252209_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/05\/desk-notes-pen-A4C6B252209_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/es\/t-sql\/gestionar-las-tablas-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"es","item":"https:\/\/expert-only.com\/es\/"},{"@type":"ListItem","position":2,"name":"Gestionar las tablas SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/es\/#website","url":"https:\/\/expert-only.com\/es\/","name":"Tutoriales de SQL y TI","description":"","publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/es\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/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\/es\/#\/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\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/#\/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\/es\/wp-json\/wp\/v2\/posts\/8481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/comments?post=8481"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/8481\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media\/6050"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media?parent=8481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/categories?post=8481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/tags?post=8481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}