Toad World® Forums

Generate schema script questions

1- I assume TOAD generates column comments in the original column orders of the table. Can you add an option where comments generation to schema scripts can be ordered by Column name beside by column ID ?

2- My other question is can you remove schema name reference in table's script when an ID column DEFAULT value references to a sequence name and 'Options|Script|Include schema name before objects name' is toggle off? And of course, just when the exported schema name and the referenced schema name (for sequence, function, package function) are have the same value.

For example:

ID NUMBER DEFAULT "MYUSER"."SAMPLE_TABLE_SEQ"."NEXTVAL" NOT NULL,

should be

ID NUMBER DEFAULT "SAMPLE_TABLE_SEQ"."NEXTVAL" NOT NULL,

#2 - yes, definitely we should take out the schema name in that case. For sequences referenced by triggers at least. We don't alter your function/procedure/package code.

#1 - ummm, to be honest, that sounds like the kind of request that only 1 user will care about.

Edit: actually, I am already ordering my SQL by table name and column name. But I see they aren't coming out that way. hmm.