Analysis results

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 Imaging Core.

What results can you expect?

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

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

• TSQLAnalyzerLinks.xls

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:

• SQLAnalyzerObjectProperties.xls

Links

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

• SQLAnalyzerLinks.xls