Commenting within the queries

[Jonny]

I'm getting lost due to multiple criterias within the queries. What's the best practice to comment the criterias?

 

[arnelgp]

put in a Table the query name, SQL string, criteria, comment
there is no facility to add comment on the query itself.

 

[Jonny]

put in a Table the query name, SQL string, criteria, comment
there is no facility to add comment on the query itself.

Good idea, thank you!

 

[isladogs]

Alternatively, you can add a comment/description to any database object such as a query which can be viewed when you use Details view in the navigation pane.

To add a description, click the object in the nav pane and select Object Properties from its context menu.

 

[Jonny]

Alternatively, you can add a comment/description to any database object such as a query which can be viewed when you use Details view in the navigation pane.

To add a description, click the object in the nav pane and select Object Properties from its context menu.

Great, thank you!

 

[isladogs]

You're welcome