def drop_table(db, table): drop(db, 'TABLE', table)

def create_table(db, table, cols=[], has_pkey=True, col_indexes=True,

    '''Creates a table.

    @param cols [sql_gen.TypedCol,...] The column names and types

    @param has_pkey If set, the first column becomes the primary key.

        * If a list reference, [0] will be set to a function to do this.

          This can be used to delay index creation until the table is populated.

    '''

    table = sql_gen.as_Table(table)

    if like != None:

        str_ += '\n, '.join(c.to_str(db) for c in cols)

        str_ += '\n);'

        try: run_query(db, str_, **opts)

        except InvalidTypeException: # try again as view

            run_query_into(db, mk_select(db, like, limit=0), into=table, **opts)

    if isinstance(col_indexes, list): col_indexes[0] = add_indexes_ # defer

    elif col_indexes: add_indexes_() # add now

    '''Creates a structure-only copy of a table. (Does not copy data.)'''

def copy_table(db, src, dest):

    '''Creates a copy of a table, including data'''