Function remove_create_table

bmtools/tools/database/utils/db_utils.py:4–5

(sql)

import sqlparse

def remove_create_table(sql):
    return re.sub(r'(create|CREATE)\s+(table|TABLE).+?\(.+?\)\s*;','',sql, flags=re.DOTALL)

def remove_create_index(sql):
    return re.sub(r'(create|CREATE)\s+(index|INDEX).+?\(.+?\)\s*;','',sql, flags=re.DOTALL)