{"id":30295,"date":"2024-02-12T06:45:00","date_gmt":"2024-02-12T05:45:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=30295"},"modified":"2024-02-29T16:33:12","modified_gmt":"2024-02-29T15:33:12","slug":"como-listar-las-tablas-en-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/","title":{"rendered":"C\u00f3mo Listar las Tablas en SQL Server?"},"content":{"rendered":"\n<p>Para auditar una base de datos MSSQL y sus tablas, es com\u00fan querer la lista de tablas en forma de tabla o una hoja de Excel. Esta consulta SQL permite listar todas las tablas en una base de datos de SQL Server y mostrar el n\u00famero de filas y el tama\u00f1o de cada tabla. Los desarrolladores de SQL Server tambi\u00e9n buscan a menudo tablas, por ejemplo, para an\u00e1lisis de impacto. Por lo tanto, es muy \u00fatil listar r\u00e1pidamente todas las tablas para una auditor\u00eda, ya sea t\u00e9cnica o funcional. Para empezar, estas tres diferentes consultas T-SQL permiten mostrar la informaci\u00f3n de diferentes maneras, y con diferentes niveles de detalles.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>La primera es una simple lista de tablas. <\/li>\n\n\n\n<li>La segunda consulta muestra informaci\u00f3n \u00fatil como la columna object_id, create_date y modify_date. <\/li>\n\n\n\n<li>La tercera consulta muestra el esquema, el n\u00famero de filas y el espacio en disco utilizado por cada tabla.<\/li>\n<\/ol>\n\n\n\n<p>De hecho, las tablas y vistas del sistema de SQL Server contienen <a href=\"https:\/\/ayudaleyprotecciondatos.es\/metadatos\/\" target=\"_blank\" rel=\"noreferrer noopener\">metadatos \u00fatiles que describen los diferentes objetos<\/a> en la base de datos, incluidas las tablas, por supuesto. As\u00ed, todas las soluciones presentadas en este art\u00edculo utilizan tablas o vistas del sistema, tales como:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>information_schema.tables<\/li>\n\n\n\n<li>sys.tables<\/li>\n\n\n\n<li>sys.indexes<\/li>\n\n\n\n<li>sys.partitions<\/li>\n\n\n\n<li>sys.allocation_units<\/li>\n\n\n\n<li>o sys.schemas<\/li>\n<\/ul>\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\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#1-mostrar-el-nombre-de-todas-las-tablas-de-sql-server-con-una-consulta\" >1. Mostrar el nombre de todas las tablas de SQL Server con una consulta<\/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\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#2-consulta-para-obtener-la-lista-de-tablas-de-sql-server-usando-la-vista-systables\" >2. Consulta para obtener la lista de tablas de SQL Server usando la vista sys.tables<\/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\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#3-mostrar-la-lista-de-nombres-y-tamanos-de-tablas-en-t-sql\" >3. Mostrar la lista de nombres y tama\u00f1os de tablas en T-SQL<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-mostrar-el-nombre-de-todas-las-tablas-de-sql-server-con-una-consulta\"><\/span>1. Mostrar el nombre de todas las tablas de SQL Server con una consulta<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>En SQL Server, information_schema.table es una vista, no una tabla. <\/strong>Es una de las vistas INFORMATION_SCHEMA estandarizadas por ISO para los sistemas de gesti\u00f3n de bases de datos relacionales (RDBMS). Esta vista proporciona informaci\u00f3n sobre las tablas y vistas presentes en una base de datos. Puedes consultarla para obtener metadatos sobre estas tablas y vistas, como sus nombres, tipos (tabla o vista) y otros detalles. Por ejemplo, puedes utilizar la tabla del sistema information_schema.table, as\u00ed:<\/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=\"\">SELECT *\nFROM   information_schema.tables\nWHERE  table_type='BASE TABLE';\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"560\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/02\/T-SQL-list-all-tables-in-sql-server-database.jpg\" alt=\"Consulta para obtener la lista de todas las tablas en SQL Server\" class=\"wp-image-30285\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2024\/02\/T-SQL-list-all-tables-in-sql-server-database.jpg 600w, https:\/\/expert-only.com\/wp-content\/uploads\/2024\/02\/T-SQL-list-all-tables-in-sql-server-database-300x280.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><figcaption class=\"wp-element-caption\"><em>Consulta para obtener la lista de todas las tablas en SQL Server<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-consulta-para-obtener-la-lista-de-tablas-de-sql-server-usando-la-vista-systables\"><\/span>2. Consulta para obtener la lista de tablas de SQL Server usando la vista sys.tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Tambi\u00e9n puedes usar la tabla del sistema sys.tables. El resultado de la consulta muestra que el tipo de tabla almacenado en la columna [type_desc] es USER_TABLE. <strong>Sys.tables en Transact-SQL tambi\u00e9n es una vista del sistema y no una tabla.<\/strong> Es parte del cat\u00e1logo del sistema de SQL Server y proporciona informaci\u00f3n sobre todas las tablas de usuarios y tablas del sistema que existen en la base de datos actual. Se puede usar para recuperar varios detalles y metadatos sobre las tablas, como su nombre, fecha de creaci\u00f3n, fecha de modificaci\u00f3n, etc. Aunque se puede consultar como una tabla, no se debe tratar como una tabla de usuario editable. En cambio, es una vista estructurada que presenta ciertos metadatos del sistema sobre las tablas.<\/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=\"\">SELECT *\nFROM   sys.tables;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-mostrar-la-lista-de-nombres-y-tamanos-de-tablas-en-t-sql\"><\/span>3. Mostrar la lista de nombres y tama\u00f1os de tablas en T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>La tercera es utilizar m\u00faltiples tablas del sistema de SQL Server como sys.tables, sys.indexes, sys.partitions, sys.allocation_units y sys.schemas. Estas tablas son \u00fatiles para mostrar la lista de tablas. Tambi\u00e9n se utilizan para mostrar el n\u00famero de filas en cada tabla y el espacio en disco utilizado. Por ejemplo, esta consulta muestra todas las tablas con su n\u00famero de filas ordenado en orden descendente. Esta consulta es \u00fatil para encontrar el tama\u00f1o de las tablas m\u00e1s grandes en una base de datos de SQL Server.<\/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=\"\">SELECT\nsch.name AS SCHEMANAME,\ntab.name AS TABLENAME,\npar.rows AS ROWCOUNTS,\nSUM(alc.total_pages) * 8 AS TOTAL_SPACE,\nSUM(alc.used_pages) * 8 AS USED_SPACE,\n(SUM(alc.total_pages) - SUM(alc.used_pages)) * 8 AS UNUSED_SPACE\nFROM sys.tables tabSELECT\n\tsch.name AS SCHEMANAME,\n\ttab.name AS TABLENAME,\n\tpar.rows AS ROWCOUNTS,\n\tSUM(alc.total_pages) * 8 AS TOTAL_SPACE,\n\tSUM(alc.used_pages) * 8 AS USED_SPACE,\n\t(SUM(alc.total_pages) - SUM(alc.used_pages)) * 8 AS UNUSED_SPACE\nFROM sys.tables tab\n\tINNER JOIN sys.indexes ind\n\t\tON tab.object_id = ind.object_id\n\tINNER JOIN sys.partitions par\n\t\tON  ind.object_id = par.object_id\n\t\tAND ind.index_id = par.index_id\n\tINNER JOIN sys.allocation_units alc\n\t\tON par.partition_id = alc.container_id\n\tLEFT OUTER JOIN sys.schemas sch\n\t\tON tab.schema_id = sch.schema_id\nGROUP BY \ttab.name, \n\t\tsch.name, \n\t\tpar.rows\nORDER BY par.rows DESC;\n<\/pre>\n\n\n\n<p>Esta lista de puntos explica la consulta anterior y c\u00f3mo se construye.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>La palabra clave \u00abORDER BY par.rows DESC;\u00bb se utiliza para ordenar la lista de tablas de SQL Server por su n\u00famero de filas, en orden descendente.<\/li>\n\n\n\n<li>Para ordenar por esquema y luego por nombre de tabla, usa \u00abORDER BY 1,2\u00bb o \u00abORDER BY sch.name, tab.name; \u00bb en su lugar. <\/li>\n\n\n\n<li>El tama\u00f1o de las tablas se indica en KiloBytes o KB.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-acerca-de-la-listacion-de-objetos-de-sql-server-y-tablas-del-sistema\">Acerca de la listaci\u00f3n de objetos de SQL Server y tablas del sistema <\/h3>\n\n\n\n<p>Este tutorial t\u00e9cnico de MS SQL Server explica c\u00f3mo crear y usar una consulta para listar todas las tablas en una base de datos dada. Si todav\u00eda eres nuevo en SQL Server y quieres crear una tabla, aqu\u00ed est\u00e1 <a href=\"https:\/\/expert-only.com\/en\/mysql\/create-table-mysql\/a\">c\u00f3mo crear una tabla de SQL Server<\/a> e insertar algunas filas de datos. Es posible mostrar otra <a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-table-size-disk-space\/\">lista de tablas de MS SQL con m\u00e1s enfoque en el espacio en disco disponible<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriales-de-sql-y-ti wp-block-embed-tutoriales-de-sql-y-ti\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/expert-only.com\/en\/t-sql\/sql-server-table-size-disk-space\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Para auditar una base de datos MSSQL y sus tablas, es com\u00fan querer la lista de tablas en forma de tabla o una hoja de Excel. Esta consulta SQL permite listar todas las tablas en una base de datos <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/\" title=\"C\u00f3mo Listar las Tablas en SQL Server?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5791,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,455],"tags":[],"class_list":{"0":"post-30295","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"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>C\u00f3mo Listar las Tablas en SQL Server? T-SQL<\/title>\n<meta name=\"description\" content=\"Consulta para listar todas las tablas de una base de datos en SQL Server, y sus atributos, como el n\u00famero de filas y el tama\u00f1o.\" \/>\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\/como-listar-las-tablas-en-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3mo Listar las Tablas en SQL Server?\" \/>\n<meta property=\"og:description\" content=\"Consulta para listar todas las tablas de una base de datos en SQL Server, y sus atributos, como el n\u00famero de filas y el tama\u00f1o.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-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=\"2024-02-12T05:45:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-29T15:33:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_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\/como-listar-las-tablas-en-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"C\u00f3mo Listar las Tablas en SQL Server?\",\"datePublished\":\"2024-02-12T05:45:00+00:00\",\"dateModified\":\"2024-02-29T15:33:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/\"},\"wordCount\":767,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/es\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg\",\"articleSection\":[\"T-SQL\",\"T-SQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/\",\"name\":\"C\u00f3mo Listar las Tablas en SQL Server? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg\",\"datePublished\":\"2024-02-12T05:45:00+00:00\",\"dateModified\":\"2024-02-29T15:33:12+00:00\",\"description\":\"Consulta para listar todas las tablas de una base de datos en SQL Server, y sus atributos, como el n\u00famero de filas y el tama\u00f1o.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"es\",\"item\":\"https:\/\/expert-only.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00f3mo Listar las Tablas en 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":"C\u00f3mo Listar las Tablas en SQL Server? T-SQL","description":"Consulta para listar todas las tablas de una base de datos en SQL Server, y sus atributos, como el n\u00famero de filas y el tama\u00f1o.","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\/como-listar-las-tablas-en-sql-server\/","og_locale":"es_ES","og_type":"article","og_title":"C\u00f3mo Listar las Tablas en SQL Server?","og_description":"Consulta para listar todas las tablas de una base de datos en SQL Server, y sus atributos, como el n\u00famero de filas y el tama\u00f1o.","og_url":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/","og_site_name":"Tutoriales de SQL y TI","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-02-12T05:45:00+00:00","article_modified_time":"2024-02-29T15:33:12+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_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\/como-listar-las-tablas-en-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/es\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"C\u00f3mo Listar las Tablas en SQL Server?","datePublished":"2024-02-12T05:45:00+00:00","dateModified":"2024-02-29T15:33:12+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/"},"wordCount":767,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/es\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg","articleSection":["T-SQL","T-SQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/","url":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/","name":"C\u00f3mo Listar las Tablas en SQL Server? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg","datePublished":"2024-02-12T05:45:00+00:00","dateModified":"2024-02-29T15:33:12+00:00","description":"Consulta para listar todas las tablas de una base de datos en SQL Server, y sus atributos, como el n\u00famero de filas y el tama\u00f1o.","breadcrumb":{"@id":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/pattern_dark_texture-design-9D617D2FB8C_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/es\/t-sql\/como-listar-las-tablas-en-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"es","item":"https:\/\/expert-only.com\/es\/"},{"@type":"ListItem","position":2,"name":"C\u00f3mo Listar las Tablas en 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\/30295","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=30295"}],"version-history":[{"count":4,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/30295\/revisions"}],"predecessor-version":[{"id":30308,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/posts\/30295\/revisions\/30308"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media\/5791"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/media?parent=30295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/categories?post=30295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/es\/wp-json\/wp\/v2\/tags?post=30295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}