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?
Please sign in to leave a comment.
Yes, you can create a ddl data source from your files, please read the article.