简要描述:

  • 生成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-07-26 14:15   作者:于春辉