abaobjecttypes (ap_obt)

Name

abaobjecttypes

Code

ap_obt

Creation Date

13 december 2000 13:53:05

Modification Date

24 september 2012 09:42:25

Comment

Object types handled by AbaPerls.


Table description

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

 

Do not modify this table in any way.


Column list


Column


Domain

Data
Type

NOT
NULL

F
K


Comment

objtype

ap_objtype

char(3)

X

 

Code for the object type

typename

ap_description

varchar(30)

X

 

Descriptive name for the object type.

createname

ap_description

varchar(30)

 

 

The word that follows CREATE


Keys

Name

Columns

Options

PK

pk_ap_obt

objtype clustered

X


objtype

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.


createname

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.


Tables referring to abaobjecttypes

Child Table

Foreign Key Columns

abahistsysobjects

objtype

abasysobjects

objtype