database_qualifier is a blank string
|
|
database_qualifier is an undefined database
|
|
table_name is undefined in the database
|
|
table_name is null
|
|
table_name is a blank string
|
|
column_name is a blank string
|
|
column_name is undefined in the table
|
database_qualifier is a blank string
|
|
database_qualifier is an undefined database
|
|
table_name is undefined in the database
|
|
table_name is null
|
|
table_name is a blank string
|
|
column_name is a blank string
|
|
column_name is undefined in the table
|
database_qualifier is a blank string
|
|
table_name is null
|
|
table_name is a blank string
|
|
column_name is a blank string
|
|
user_name is a blank string
|
Legend: PkQ = Pkey_ table_ qualifier; PkO = Pkey_table_owner; PkT = Pktable_ name; PkCol = Pk_ column_ name; Seq = Key_seq; FkQ = Fktable_qualifier; FkO = Fktable_owner; FkT = Fktable_name; FkCol = Fkcolumn_name; UR = Update_rule; DR = Delete_rule; Pk = Pk_ name; FK = Fk_ name
|
table_qualifier is a blank string
|
|
pKey_table_name is a blank string
|
|
pKey_table_name is null
|
|
fKey_table_name is a blank string
|
database_qualifier is a blank string
|
|
group_name is a blank string
|
database_qualifier is a blank string or null
|
|
procedure_name is null
|
|
procedure_name is a blank string
|
database_qualifier is a blank string
|
|
trigger_name is null
|
|
trigger_name is a blank string
|
database_qualifier is a blank string
|
|
udf_name is null
|
|
udf_name is a blank string
|
database_qualifier is a blank string
|
|
view_name is null
|
|
view_name is a blank string
|
Legend: Qual = Table_ qualifier; TO = Table_owner; TN = Table_name; IN = Index_name; IT = Index_type; CN = Column_name; Opos = Ordinal_position; Dup = Duplicates_allowed; UP = Updatable; Case = Case_ sensitive; A/D = Asc_desc; NI = Named_index
|
Legend: Qual = Table_ qualifier; TO = Table_owner; TN = Table_name; IN = Index_name; IT = Index_type; CN = Column_name; Opos = Ordinal_position; Dup = Duplicates_allowed; UP = Updatable; Case = Case_ sensitive; A/D = Asc_desc; NI = Named_index
|
database_qualifier is a blank string
|
|
table_name is a blank string
|
pkey_table_qualifier is a blank string
|
|
table_name is null
|
|
table_name is a blank string
|
database_qualifier is a blank string
|
|
procedure_name is a blank string
|
|
user_name is a blank string
|
|
A user-defined name for the object. The name must conform to the naming conventions for the type of object. See Naming Conventions in Pervasive PSQL Programmer's Guide in the Developer Reference.
|
||
'SP' returns the stored procedures
'SSP' returns the system stored procedures (this type is currently not supported)
|
Name1
|
Type1
|
|||||||
1The complete column name includes “procedure_” prepended to this name: Procedure_qualifier, procedure_owner, and so forth.
|
Name1
|
Type1
|
|||||||
1The complete column name includes “procedure_” prepended to this name: Procedure_qualifier, procedure_owner, and so forth.
|
database_qualifier is a blank string
|
|
table_name is a blank string
|
|
procedure_type is a blank string
|
|
procedure_type is a value other than SP, SSP, or null
|
'User table' returns only the user tables
'System table' returns all the system tables
|
System table - if the table is a system table
User table - if the table has been created by any user
|
||
database_qualifier is a blank string
|
|
table_name is a blank string
|
|
table_type is a blank string
|
|
table_type is something other than 'system table,' 'user table,' or null
|
database_qualifier is a blank string
|
|
table_name is a blank string
|
|
user_name is a blank string
|
database_qualifier is a blank string
|
|
table_name is a blank string
|
database_qualifier is a blank string
|
|
udf_name is a blank string
|
database_qualifier is a blank string
|
|
user_name is null
|
|
group_name is a blank string
|
database_qualifier is a blank string
|
|
view_name is a blank string
|
|
user_name is a blank string
|
|
database_qualifier is a blank string
|
|
view_name is a blank string
|