Method recreateTable

plugins/destination/duckdb/client/migrate.go:169–175

(ctx context.Context, table *schema.Table)

}

func (c *Client) recreateTable(ctx context.Context, table *schema.Table) error {
	sql := "drop table if exists " + sanitizeID(table.Name)
	if err := c.exec(ctx, sql); err != nil {
		return err
	}
	return c.createTableIfNotExist(ctx, table.Name, table, false)
}

func (c *Client) addColumn(ctx context.Context, tableName string, columnName string, columnType string) error {
	sql := "alter table " + sanitizeID(tableName) + " add column " + sanitizeID(columnName) + " " + columnType