Navigation:  Form >

Pivot table security

 Previous  Top  Next

Overview

This command will return whether the table inherits the security list from the table type.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

EFENTITYCONFIG

Table that stores the pivot table configuration

PKEFENTITYCONFIG

EMENTITYMODEL

Table that stores the pivot table data

PKEMENTITYMODEL

 

Oracle/Postgres/SQL Server

SELECT 
* 
FROM 
EFENTITYCONFIG 
WHERE 
OIDENTITY IN (SELECT OID FROM EMENTITYMODEL WHERE IDNAME='database') /* NOTE1 */

 

Notes

▪1: Pivot table ID #.

 

Fields used on the view screen

 

form-03

 

#

Field ID

Type

Description

1

IDNAME

VARCHAR(50)