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.