---
title: "生成变更SQL"
method: POST
path: "/v1/projects/{project_name}/database_comparison/modify_sql_statements"
tags: ["database_comparison"]
---

# 生成变更SQL

`POST /v1/projects/{project_name}/database_comparison/modify_sql_statements`

generate database diff modify sqls

## Path parameters

- `project_name` string, required

## Request body

- V1GenModifylSQLReqV1
  - `base_instance_id` string
  - `comparison_instance_id` string
  - `database_schema_objects` V1DatabaseSchemaObject[]
    - `base_schema_name` string
    - `comparison_schema_name` string
    - `database_objects` V1DatabaseObject[]
      - `object_name` string
      - `object_type` 'TABLE' | 'VIEW' | 'PROCEDURE' | 'TIGGER' | 'EVENT' | 'FUNCTION'

## Response `200`

OK

---

[API](https://skmtc.dev/actiontech/apis/sqle-api-docs.md) · [All operations](https://skmtc.dev/actiontech/apis/sqle-api-docs/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/actiontech/sqle-api-docs/revisions/3e36a0067703/schema)