abaobjecttypes (ap_obt)

This is a pre-loaded table that defines which type of objects that AbaPerls tracks.

Do not modify this table in any way.

The codes agree with the values in sys.objects.type for the object types that SQL Server stores in sys.objects. Note that sys.objects.type has a few more possible values that are not present in abaobjecttypes, as AbaPerls does not handle these object types.

For object types stored elsewhere than in sys.objects, including those invented by AbaPerls itself, AbaPerls uses a code that is three characters long.

AF - Aggregate function

C - CHECK constraint

D - Default

F - Foreign key

FN - Scalar Function

FS - CLR scalar function

IF - Inline Table Function

PK - Primary key

FT - CLR table-valued function

P - Stored procedure

PC - CLR stored procedure

R - Rule

SO - Sequence object

SN - Synonym

TA - CLR trigger

TF - Multi-statment Function

TR - Trigger

U - Table

UQ - UNIQUE

V - View

ASS - Assembly

DDL - DDL trigger

IDX - Index

FIL - Object-less file

STA - Statistics

TYP - Datatype

TTY - Table type

XSC - XML schema

-- Service Broker

MTY - Message type

CON - Contract

SQ - Queue

SER - Service

BRP - Broker priorty

Objects of the type FIL is typically include-files or INSERT-files, but it could be any file in which AbaPerls for some reason does not find any SQL object. If you see a file with the extension .SP loaded as an object with the type FIL, there is probably something funky with that file, for instance weird formatting that AbaPerls does not parse.

Many object types are created with a CREATE xxx statement. This column specifies what xxx is for the object type in question. The column in used in places where AbaPerls is dropping many types of objects, for instance objects that refers an assembly that needs to be dropped.