简要描述:
- 生成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"
}备注:
- 更多返回错误代码请看首页的错误代码描述
最后编辑: 于春辉  文档更新时间: 2025-04-10 14:10   作者:于春辉
