Function getRenameColumnSQL

packages/sql/src/schema/SchemaHelper.ts:223–232

Returns SQL to rename a column in a table.

(tableName: string, oldColumnName: string, to: Column, schemaName?: string)

  /** Returns SQL to rename a column in a table. */
  getRenameColumnSQL(tableName: string, oldColumnName: string, to: Column, schemaName?: string): string {
    tableName = this.quote(tableName);
    oldColumnName = this.quote(oldColumnName);
    const columnName = this.quote(to.name);

    const schemaReference = schemaName !== undefined && schemaName !== 'public' ? '"' + schemaName + '".' : '';
    const tableReference = schemaReference + tableName;

    return `alter table ${tableReference} rename column ${oldColumnName} to ${columnName}`;
  }

  /** Returns SQL to create an index on a table. */
  getCreateIndexSQL(tableName: string, index: IndexDef): string {