基础说明
支持内核：Presto、SparkSQL。
用途：查看视图的列信息。
标准语法
SHOW COLUMNS IN view_name;
参数
view_name：视图名称。
示例
SHOW COLUMNS IN view_test
﻿

","showToc":true,"toc":"

标准语法

参数

示例

","recentReleaseTime":"2023-03-08 16:30:38","videoConfig":{"position":"top"},"githubUrl":"https://github.com/tencentyun/qcloud-documents/blob/master/product/大数据与AI/数据湖计算/SQL语法/DDL语法/SHOW%20COLUMNS%20IN%20VIEW.md","isSlate":true,"writeNodeId":"96453877326905344","displayEditEntry":true,"slate":"\"[{\\\"children\\\":[{\\\"text\\\":\\\"基础说明\\\"}],\\\"nodeId\\\":\\\".E5.9F.BA.E7.A1.80.E8.AF.B4.E6.98.8E\\\",\\\"type\\\":\\\"h2\\\"},{\\\"children\\\":[{\\\"text\\\":\\\"支持内核：Presto、SparkSQL。\\\"}],\\\"type\\\":\\\"uli\\\",\\\"start\\\":false},{\\\"children\\\":[{\\\"text\\\":\\\"用途：查看视图的列信息。\\\"}],\\\"type\\\":\\\"uli\\\",\\\"start\\\":false},{\\\"children\\\":[{\\\"text\\\":\\\"标准语法\\\"}],\\\"nodeId\\\":\\\".E6.A0.87.E5.87.86.E8.AF.AD.E6.B3.95\\\",\\\"type\\\":\\\"h2\\\"},{\\\"children\\\":[{\\\"children\\\":[{\\\"text\\\":\\\"SHOW COLUMNS IN view_name;\\\"}],\\\"type\\\":\\\"code-line\\\"}],\\\"type\\\":\\\"code-block\\\",\\\"language\\\":\\\"java\\\",\\\"autoWrap\\\":false},{\\\"children\\\":[{\\\"text\\\":\\\"参数\\\"}],\\\"nodeId\\\":\\\".E5.8F.82.E6.95.B0\\\",\\\"type\\\":\\\"h2\\\"},{\\\"children\\\":[{\\\"text\\\":\\\"view_name\\\",\\\"code\\\":1},{\\\"text\\\":\\\"：视图名称。\\\"}],\\\"type\\\":\\\"p\\\"},{\\\"children\\\":[{\\\"text\\\":\\\"示例\\\"}],\\\"nodeId\\\":\\\".E7.A4.BA.E4.BE.8B\\\",\\\"type\\\":\\\"h2\\\"},{\\\"children\\\":[{\\\"children\\\":[{\\\"text\\\":\\\"SHOW COLUMNS IN view_test\\\"}],\\\"type\\\":\\\"code-line\\\"}],\\\"type\\\":\\\"code-block\\\",\\\"language\\\":\\\"java\\\",\\\"autoWrap\\\":false},{\\\"type\\\":\\\"p\\\",\\\"children\\\":[{\\\"text\\\":\\\"\\\"}]}]\"","sdkPath":"//qcloudimg.tencent-cloud.cn/static/document/tea-slate-sdk.v0.1.15-fix-v4"},"relationConfig":{"switch":0},"shareConfig":[],"advanced":[]},"relatedHotArticleList":[]},"staticContext":{"isMobile":false,"isMiniProgram":false,"isWechat":false,"isPreview":false,"originalUrl":"/document/product/1342/81052","CDN_DOMAIN":"cloudcache.tencent-cloud.com","QCLOUD_DOMAIN":"cloud.tencent.com.cn","isLegalReferer":true,"ssrInfo":{},"language":"zh","requestId":"5wW799PSan"}},"0-0":null},"actionData":null,"errors":null}

SHOW COLUMNS IN VIEW

本页目录：

基础说明

标准语法

参数

示例