I am trying to import data from a dsv file to a hsql database but for that I have to disable the constraints on the schema. There was a command like Alter Schemaname or similar, but i don't remember details.
Asked
Active
Viewed 398 times
0
Laurenz Albe
- 209,280
- 17
- 206
- 263
TAJINDER SINGH
- 49
- 1
- 9
-
[probably the answer is here](https://stackoverflow.com/questions/14972816/how-to-disable-constraints-for-all-the-tables-and-enable-it) – muneeb_ahmed Jan 21 '18 at 16:47
1 Answers
0
SET DATABASE REFERENTIAL INTEGRITY FALSE; // to disable REFERENTIAL INTEGRITY
Documentation link is here
Anurag Sharma
- 2,409
- 2
- 16
- 34
-
will this query work : ALTER SCHEMANAME SET REFERENTIAL_INTEGRITY FALSE; – TAJINDER SINGH Jan 21 '18 at 20:10