Thank you so much for your help! It worked!!!
I created a script that exports all the tables from my schema, and based on
that, I created a script that runs the ALTER TABLE commands for all the
exported tables.
All the best,
Bogdan
PS: For anyone else who needs a few more details:
The sql to export my tables is :
CALL CSVWRITE('./schema/public_tables.csv', 'SELECT TABLE_NAME FROM
INFORMATION_SCHEMA.TABLES WHERE
TABLE_SCHEMA=''PUBLIC''','writeColumnHeader=false fieldDelimiter=');
The bash script that creates the check script is:
tables_csv_file=./schema/public_tables.csv
check_consistency_sql_file=./schema/check_consistency.sql
echo Starting to write
check_consistency_sql_file=$check_consistency_sql_file
rm "$check_consistency_sql_file"
while read table_name; do
echo "ALTER TABLE $table_name SET REFERENTIAL_INTEGRITY TRUE
CHECK;">>$check_consistency_sql_file
done <$tables_csv_file
echo Finished writing check_consistency_sql_file
PPS: I think it would have been better to generate the sql check script
file directly with the CSVWRITE command, but I didn't want to spend more
time on this.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/cf47d7d7-04b4-4a24-afc4-fa38823ba87fn%40googlegroups.com.
