Page tree
Skip to end of metadata
Go to start of metadata
The information below is valid only for the legacy PL/SQL and T-SQL analyzers embedded in CAST AIP. See SQL - Available extensions for information about SQL related extensions.


Summary: This document provides information about the analysis results you can expect from an analysis of SQL technologies using the legacy PL/SQL and T-SQL analyzers embedded in CAST AIP.

What results can you expect?

Once the analysis/snapshot generation has completed, you can view the results in the normal manner (for example via CAST Enlighten):

Microsoft SQL Server and Sybase ASE T-SQL

Objects

Instance
Database
Schema
Trigger
Function
Procedure
Table
View
Table Column / View Column
Index, Foreign Key Constraint, Primary Key Constraint, Unique Constraint

Links detected by the SQL Analyzer are listed in the attached Excel file:

Oracle PL/SQL

Objects

Collection Nested Table Type

Collection Varray

Cursor

Database Link

Function

Function (Private)

Instance

Index, Foreign Key Constraint, Primary Key Constraint, Check Constraint and Unique Key Constraint

Object Type (Incomplete, Body and Header)

Package Body

Package Header

Procedure

Procedure (Private)

Schema

Schema (Unknown)

Sequence

Synonym (Public/Private)

Table

Table Column

Trigger

View (Normal and Materialized)

View Column

Object properties that are supported by the current release of the embedded SQL analyzer are described in the attached Excel file:

Links

Links detected by the embedded SQL analyzer are listed in the attached Excel file:

  • No labels