Toad World® Forums

Format CREATE TYPE ,CREATE TABLE and RECORD TYPE

What option should I use at Options|Formatter to align table and column references to an offset position when script or code contains CREATE TABLE, CREATE RECORD or CREATE TYPE statements? All column references (the data type) follow the column aliases by one space. I'm unable to align the data type at offset 30, for example.

See pic. Variable declaration alignment doesn't work for CREATE TYPE as it is not a variable declaration. Currently there is no setting for this.

Hope this helps,
Andre

My option is Fixed, and Align types offset is set to 30. But there is no align at all for CREATE TABLE and CREATE RECORD statements. Local variables and parameters of procs|funcs are correctly aligned at offset 30.

Would you plan to support align for CREATE TYPE statements in a future release?

thanks.

Andre,

Can you confirm please, that align is not applied for create record and create table statements when option set to Fixed at position 30? Thanks.