Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Redirect
visiblefalse
locationAIPCONSOLE:KB Update SQL Tool - Removing an object property using CI_NO_PROPERTIES

Panel
Table of Contents

Object properties can be divided into two main groups:

...

These can all be removed using the CAST entry table CI_NO_PROPERTIES. Properties are listed in the CAST System View CTV_OBJECT_PROPERTIES.

Based on object's ID

In this example, we are going to remove a property from an SQL object (a Procedure called "GetTitleAuthors") in the CAST Analysis Service. The property we are going to remove is the Source Code Comments, which is described in the Analysis Service as "sourceCodeComment".
You can check the value for this property by querying a CAST System View:

...

You can also check in CAST Enlighten.

Based on object's GUID

From an object with an OBJECT_GUID

In this example, we are going to remove a property from a C++ object (a Function called "print_header ()") in the CAST Analysis Service. The property we are going to remove is the Number of inner comment lines, which is described in the Analysis Service as "BodyCommentLinesCount".
You can check the value for this property by querying a CAST System View:

...

You can also check in CAST Enlighten.

From an object without an OBJECT_GUID

In this example, we are going to remove a property from a T-SQL server object (a stored procedure called "GetAuthors") in the CAST Analysis Service. The property we are going to remove is the Number of code lines, which is described in the Analysis Service as "CodeLinesCount".
You can check the value for this property by querying a CAST System View:

...

You can also check in CAST Enlighten.