Datatype Alignment for Create Table

3 Posts
2 Users
0 Reactions
329 Views
(@lamprey)
Member
Joined: 2 years ago
Posts: 8
Topic starter  

This appears to be the default behavior for create table as well as JOIN ON clauses where SQL Inform tried to align things for you automatically. I don't see a setting to disable this feature, but if it exists, please let me know. Although, they don't seem to apply here, I have all the Alignment options de-selected.

As an example, if I have a create table like:

create table foo
    (
        fooid int
        ,bar1 int
        ,barbarbarbar3 int
    )

after formatting, SQL Inform aligns all the data types like this:

create table foo
    (
        fooid           int
        , bar1          int
        , barbarbarbar3 int
    )

Likewise, for join conditions if I have a select:

select
	foo
from
	table1 as t1
join
	table2 as t2
	on t1.id = t2.id
	and t1.val = t2.val

after formatting SQL inform aligns the join clause by adding spaces:

select
    foo
from
    table1 as t1
join
    table2 as t2
    on  t1.id = t2.id
    and t1.val = t2.val

 

As mentioned, that appears to be the default behavior but, if that can be turned off, please let me know which setting to change.

Thanks!


   
Quote
Guido
(@admin)
Member Admin
Joined: 3 years ago
Posts: 234
 

Hi Lamprey,

for the CREATE TABLE, please try this option

grafik

Currently there is no way to avoid the added spaces after the ON keyword like aftwe the FRoM, WHERE,... keywords

Regards

Guido


   
ReplyQuote
(@lamprey)
Member
Joined: 2 years ago
Posts: 8
Topic starter  

That did the trick! 

 

Thanks Guido!


   
ReplyQuote
Share: