abastorageproperties (ap_stp)

Name

abastorageproperties

Code

ap_stp

Creation Date

4 februari 2013 12:24:50

Modification Date

30 december 2021 10:21:19

Comment

Physical props for tables and indexes.


Table description

This is a look up table that holds various physical storage properties for tables and indexes tracked by AbaPerls. The currently available values are:

 

ALLOW_PAGE_LOCKS

ALLOW_ROW_LOCKS

COMPRESSION

FILEGROUP

FILESTREAM_ON

FILLFACTOR

LOB out of row

lock on bulk load

LOCK_ESCALATION

OPTIMIZE_FOR_SEQUENTIAL_KEY

PAD_INDEX

STATISTICS_NORECOMPUTE

text in row

TEXTIMAGE_ON

vardecimal


Column list


Column


Domain

Data
Type

NOT
NULL

F
K


Comment

property

ap_property

varchar(30)

X

 

 


Keys

Name

Columns

Options

PK

pk_ap_stp

property clustered

X


Tables referring to abastorageproperties

Child Table

Foreign Key Columns

abaobjectstoragesettings

property