Index display problem

[xxcc520]

The index cannot be displayed correctly in DDL, v3.4.17

[pawelsalawa]

What's actual DDL of the index? You can see it by executing:

SELECT sql FROM sqlite_master WHERE name = 'your_index_name_here'

[xxcc520]

My own question, is it possible to add an sql compression and change multiple lines into one line?

[pawelsalawa]

Do you mean in resulting sql of the query above?

[xxcc520]

No, I mean when writing sql, at present, only formatted sql is available. Can you add a compressed sql, that is, it can become a line? If not, it doesn't matter. You can close this question.

[pawelsalawa]

The query pI posted above will give you SQL just as it was created. The DDL tab in Index Dialog shows it preformatted. There are no other views available.