说明
支持内核：Presto、SparkSQL。
用途：展示创建视图的语句。
语法
SHOW CREATE VIEW view_name
参数
view_name：视图名称。
示例
SHOW CREATE VIEW orders_by_date
﻿

","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%20CREATE%20VIEW.md","isSlate":true,"writeNodeId":"96453877208416256","displayEditEntry":true,"slate":"\"[{\\\"children\\\":[{\\\"text\\\":\\\"说明\\\"}],\\\"nodeId\\\":\\\".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\\\":\\\".E8.AF.AD.E6.B3.95\\\",\\\"type\\\":\\\"h2\\\"},{\\\"children\\\":[{\\\"children\\\":[{\\\"text\\\":\\\"SHOW CREATE VIEW 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 CREATE VIEW orders_by_date\\\"}],\\\"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.11"},"relationConfig":{"switch":0},"shareConfig":[],"advanced":[]},"relatedHotArticleList":[]},"staticContext":{"isMobile":false,"isMiniProgram":false,"isWechat":false,"isPreview":false,"originalUrl":"/document/product/1342/61785","CDN_DOMAIN":"cloudcache.tencent-cloud.com","QCLOUD_DOMAIN":"cloud.tencent.com","isLegalReferer":true,"ssrInfo":{},"language":"zh","requestId":"rAtuv9GIN0"}},"0-0":null},"actionData":null,"errors":null}

SHOW CREATE VIEW

本页目录：

说明

语法

参数

示例