|
Name |
abaprocparamcache |
|
Code |
ap_ppc |
|
Creation Date |
26 mars 2013 10:11:13 |
|
Modification Date |
26 mars 2013 10:39:30 |
|
Comment |
Holds information about defaultable parameters. |
|
This table exists mainly to supplement sys.parameters which does not hold information whether a parameter for a T-SQL procedure has a default value. (There is a column for this in sys.parameters, but it applies to CLR procedures only.) In order not having to parse the same procedure again and again, AbaPerls maintains this cache. The table is not restricted to objects in abasysobjects, but AbaPerls also caches information for other procedures, including procedures in other databases and system procedures. |
|
|
|
Data |
NOT |
F |
|
|
|
sysname |
X |
|
|
|
|
|
int |
X |
|
Same as in sys.parameters. |
|
|
paramno |
|
smallint |
X |
|
Same as in sys.parameters. |
|
hasdefault |
|
bit |
X |
|
Wether parameter accepts a default. |
|
|
datetime |
X |
|
Taken from sys.objects. |
|
Name |
Columns |
Options |
PK |
|
pk_ap_ppc |
db | clustered |
X |
|
The database for the stored procedure. Blank if the procedure is in the current database (so that information still holds if the database is restored under a different name.) |
|
Object id for the procedure within the database. |
|
Taken from sys.objects. If the value in abaprocparamcache differs from sys.objects, the cache entry is no longer valid. |
|
|
|