import csv import os def generate_sql_script(file_path): with open(file_path, mode='r') as file: csv_reader = csv.DictReader(file) table_name = None columns = [] for row in csv_reader: if table_name is None: table_name = row['TableName'] columns.append(f"{row['columnae']} {row['vartype']}({row['LENGTH']})") columns_str = ", ".join(columns) sql_script = f"CREATE TABLE {table_name} ({columns_str});" return sql_script # Example usage file_path = 'path_to_your_csv_file.csv' sql_script = generate_sql_script(file_path) print(sql_script)