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. |
This is a pre-loaded table that defines which type of objects that AbaPerls tracks.
Do not modify this table in any way. |
|
|
Data |
NOT |
F |
|
char(3) |
X |
|
Code for the object type |
||
typename |
varchar(30) |
X |
|
Descriptive name for the object type. |
|
varchar(30) |
|
|
The word that follows CREATE |
Name |
Columns |
Options |
PK |
pk_ap_obt |
objtype | clustered |
X |
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. |
Child Table |
Foreign Key Columns |
objtype |
|
objtype |
|
|
|