Commenting within the queries (1 Viewer)

Jonny

Registered User.
Local time
Today, 16:49
Joined
Aug 12, 2005
Messages
144
I'm getting lost due to multiple criterias within the queries. What's the best practice to comment the criterias?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 22:49
Joined
May 7, 2009
Messages
19,175
put in a Table the query name, SQL string, criteria, comment
there is no facility to add comment on the query itself.
 

Jonny

Registered User.
Local time
Today, 16:49
Joined
Aug 12, 2005
Messages
144
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

MVP / VIP
Local time
Today, 14:49
Joined
Jan 14, 2017
Messages
18,186
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.
 

Attachments

  • Capture.PNG
    Capture.PNG
    29.1 KB · Views: 341

Jonny

Registered User.
Local time
Today, 16:49
Joined
Aug 12, 2005
Messages
144
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!
 

Users who are viewing this thread

Top Bottom