FK constraints

[oojacoboo]

Am I correct that this script doesn't currently work if a table has any objects depending on it, ala FK constraints? There is an option to cascade a DROP statement in this situation, but obviously, those FK constraints would need to be recreated.

[oojacoboo]

So, after further examination, it seems the issue is related to quoted identifiers. When using a quoted identifier for a table, it doesn't find the relations.

[GammaGames]

Hmm, do you have a simple example database I could use to test it on? I could see the quoted identifiers causing issues

[oojacoboo]

Unfortunately I don't have an example database, but this happened on a user table. That's a reserved word, so it must be quoted. I was able to pass a quoted string through the table argument. But it doesn't seem to work when getting the FK relations. Luckily we don't have many reserved keyword tables, so it's not a huge issue, but it would be nice if it supported this.

I also tried to do a refactor, but ran into some issues with it and gave up.