renameTable_link管理

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

威武的毛豆 · 18. 连接数据库 — Python ...· 2 月前 ·

打酱油的手套 · 原神同人志空X刻晴（十六） - 哔哩哔哩· 4 月前 ·

可爱的豆芽 · serialize Cert ...· 9 月前 ·

有腹肌的啄木鸟 · Angular 初认识 | 昕小阳的博客· 11 月前 ·

温柔的酱牛肉 · request()获取url后面的参数_ph ...· 1 年前 ·

To run this Change Type , follow these steps:

Add the Change Type to your changeset , as shown in the examples on this page.

Specify any required attribute s. Use the table on this page to see which ones your database requires.

Deploy your changeset by running the


    
     update

command:

liquibase update

Available attribute s

Description Required for Supports

<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
    xmlns:pro="http://www.liquibase.org/xml/ns/pro"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
        http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-latest.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd
        http://www.liquibase.org/xml/ns/pro http://www.liquibase.org/xml/ns/pro/liquibase-pro-latest.xsd">
    <changeSet  author="liquibase-docs"  id="renameTable-example">
        <renameTable  catalogName="cat"
            newTableName="employee"
            oldTableName="person"
            schemaName="public"/>
    </changeSet>
</databaseChangeLog>

databaseChangeLog:
-  changeSet:
    id:  renameTable-example
    author:  liquibase-docs
    changes:
    -  renameTable:
        catalogName:  cat
        newTableName:  employee
        oldTableName:  person
        schemaName:  public

"databaseChangeLog": [ "changeSet": { "id": "renameTable-example", "author": "liquibase-docs", "changes": [ "renameTable": { "catalogName": "cat", "newTableName": "employee", "oldTableName": "person", "schemaName": "public"

--liquibase formatted sql
--changeset liquibase-docs:renameTable-example
ALTER  TABLE  cat.person  RENAME TO  cat.employee;

Database support

Database Notes Auto Rollback