简要描述:
- 生成DDL
接口版本:
版本号 | 制定人 | 制定日期 | 修订日期 |
---|---|---|---|
1.0 | 鲁航 | 2022-08-19 | 2022-08-19 |
请求URL:
- /je/meta/resourceTable/view/generateViewDdl
请求方式:
- POST
请求头:
参数名 | 是否必须 | 类型 | 说明 |
---|---|---|---|
Content-Type | 是 | string | 请求类型: application/json |
authorization | 是 | string | 请求内容签名 |
请求参数:
参数名 | 是否必须 | 类型 | 说明 |
---|---|---|---|
strData | 是 | string | 视图信息 |
返回示例:
正确时返回:
{
"code": "1000",
"data": "CREATE VIEW JE_DEMO_KHXIANGMU_REPORT_C AS SELECT\n JE_DEMO_KHXX.KHXX_KHMC AS KHXX_KHMC,\n JE_DEMO_KHXX.KHXX_KHBM AS KHXX_KHBM,\n JE_DEMO_KHXX.KHXX_KHZLXR AS KHXX_KHZLXR,\n JE_DEMO_KHXX.KHXX_ZLXRDH AS KHXX_ZLXRDH,\n JE_DEMO_KHXX.KHXX_KHDZ AS KHXX_KHDZ,\n JE_DEMO_KHXX.JE_DEMO_KHXX_ID AS JE_DEMO_KHXX_ID,\n JE_DEMO_CLOUD_XHJ_XMGL.XMGL_BM AS XMGL_BM,\n JE_DEMO_CLOUD_XHJ_XMGL.XMGL_MC AS XMGL_MC,\n JE_DEMO_CLOUD_XHJ_XMGL.XMGL_HTJE AS XMGL_HTJE,\n JE_DEMO_CLOUD_XHJ_XMGL.JE_DEMO_CLOUD_XHJ_XMGL_ID AS JE_DEMO_CLOUD_XHJ_XMGL_ID \nFROM\n JE_DEMO_KHXX,\n JE_DEMO_CLOUD_XHJ_XMGL \nWHERE\n 1=1 \n AND JE_DEMO_KHXX.JE_DEMO_KHXX_ID=JE_DEMO_CLOUD_XHJ_XMGL.XMGL_MC",
"message": "操作成功!",
"success": true,
"rows": null,
"totalCount": null
}
错误时返回:
{
"errcode": 500,
"errmsg": "invalid appid"
}
备注:
- 更多返回错误代码请看首页的错误代码描述
最后编辑: 于春辉 文档更新时间: 2024-08-08 13:51 作者:于春辉