Print create SQL statement for tales and indices defined with SQLAlchemy

sqlalchemy_create_statement.py

from sqlalchemy import create_engine, Table, MetaData
from sqlalchemy.schema import CreateIndex, CreateTable

metadata = MetaData()

engine = create_engine('')


def create_table_statement(connection, table):
    stmts = []
    stmts.append(CreateTable(table).compile(connection))

    for index in table.indexes:
        stmts.append(CreateIndex(index).compile(connection))

    return stmts


for s in create_table_statement(engine, my_table):
    print(s)