Options : Comments

ApexSQL Clean offers the feature to exclude certain text passages from the analysis (for example, comment in a client programming language such as C# or VB.NET). In this step you can specify which tokens will be ignored during the analysis. Single-line comment tokens are as well supported as multi-line comment tokens. By default, you don't have to specify the Transact-SQL comment tokens --, /*, and */.

This functionality supports single and multi-line comments.

tip.jpg

 

Tech Tip:

 

Comments in this section are for File Analysis only – they will be automatically ignored by SQL database itself.

 

06.JPG

For information about the available buttons in the Wizard step above click here.

Examples

This is an example showing single lines comment in source code file:

image231.jpg

In this example, in the case of adding "//" single line comment in this Wizard step, ApexSQL Clean won't consider [HumanResources].[Employee] reference into analysis.

This is an example showing multi lines comment in source code file:

image232.jpg

In this example, in the case of adding "/*…*/" multi line comment in this step, ApexSQL Clean won't consider [HumanResources].[Employee] and [Person].[Contact] references into analysis.