SQL inspection combining several files

Answered

I have sql files separated in tables creation, views definition, foreign key and data insertion.

If, for example, I edit a view definition file the inspector highlights the statement with no table defined for the select clause. Those statements exist in the table creation files.

Is there a way to tell the inspector to take into consideration other files as part of the sql validation?

0
1 comment
Avatar
Yuriy Vinogradov

Yes, you can create a ddl data source from your files, please read the article.

0

Please sign in to leave a comment.