SQL_Arbitrary_Table_Create.py

# -*- coding: utf-8 -*-
"""
Created on Thu Jan 26 01:03:19 2017

@author: Shabaka
"""

# Import Table, Column, String, Integer, Float, Boolean from sqlalchemy
from sqlalchemy import Table, Column, String, Integer, Float, Boolean

# Define a new table with a name, count, amount, and valid column: data
data = Table('data', metadata,
             Column('name', String(255)),
             Column('count', Integer()),
             Column('amount', Float()),
             Column('valid', Boolean())
)

# Use the metadata to create the table
metadata.create_all(engine)

# Print table repr
print(repr(data))