Category: Operations
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| ServerID | BYTE(6) NOT NULL | X(12) | The identifier of the FOREIGN SERVER (TVMId column in DBC.TVM). |
| DataBaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the database or user in which the subject foreign server resides. |
| ServerName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the FOREIGN SERVER. |
| CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The user who issued the CREATE FOREIGN SERVER statement |
| CreateTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The time when CREATE FOREIGN SERVER statement was issued. |
| LastAlterName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The name of the user who last updated the dictionary row. |
| LastAlterTimeStamp | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS | The time the dictionary row was last updated. |
| AuthorizationName | VARCHAR(128) UNICODE UPPERCASE | X(128) | The authorization name specified in the external security clause of the foreign server. |
| AuthorizationType | VARCHAR(15) UNICODE NOT CASESPECIFIC | X(15) | The type of authorization INVOKER TRUSTED or DEFINER TRUSTED. |
| ExecMapName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The execution map name of a foreign server. NULL indicates the foreign server does not have a execution map. |
| ExecMapColocName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ColocationName of the execution map of a foreign server. |
| TableFormat | VARCHAR | X(9) | Returns the table format type (ICEBERG, DELTALAKE, or HUDI) for a datalake object. |
| CatalogAuthName | VARCHAR | X(128) | Returns the catalog authorization name for a datalake object. |