Skip to main content

INFORMATION.SCHEMA.FOREIGNTABLES

persistent class INFORMATION.SCHEMA.FOREIGNTABLES extends %Library.Persistent [ Final ]

SQL Table Name: INFORMATION_SCHEMA.FOREIGN_TABLES

This table has one row for each Foreign Table the users is privileged for in the current namespace

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

property ClassName as %String (MAXLEN = 256) [ SqlFieldName = CLASSNAME , Required ];
Name of the class that projects this foreign table
Property methods: ClassNameDisplayToLogical(), ClassNameGet(), ClassNameIsValid(), ClassNameLogicalToDisplay(), ClassNameLogicalToOdbc(), ClassNameNormalize(), ClassNameSet()
property Description as %String (MAXLEN = 256) [ Calculated , SqlFieldName = DESCRIPTION ];
Property methods: DescriptionCompute(), DescriptionDisplayToLogical(), DescriptionGet(), DescriptionIsValid(), DescriptionLogicalToDisplay(), DescriptionLogicalToOdbc(), DescriptionNormalize(), DescriptionSQLCompute()
property Owner as %String (MAXLEN = 256) [ Calculated , SqlFieldName = OWNER ];
Property methods: OwnerCompute(), OwnerDisplayToLogical(), OwnerGet(), OwnerIsValid(), OwnerLogicalToDisplay(), OwnerLogicalToOdbc(), OwnerNormalize(), OwnerSQLCompute()
property ParameterString as %String (MAXLEN = 3200) [ Calculated , SqlFieldName = PARAMETERS ];
Property methods: ParameterStringCompute(), ParameterStringDisplayToLogical(), ParameterStringGet(), ParameterStringIsValid(), ParameterStringLogicalToDisplay(), ParameterStringLogicalToOdbc(), ParameterStringNormalize(), ParameterStringSQLCompute()
property SERVERNAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = SERVER_NAME , Required ];
Name of the foreign server for this table.
Property methods: SERVERNAMEDisplayToLogical(), SERVERNAMEGet(), SERVERNAMEIsValid(), SERVERNAMELogicalToDisplay(), SERVERNAMELogicalToOdbc(), SERVERNAMENormalize(), SERVERNAMESet()
property SERVERSCHEMA as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = SERVER_SCHEMA , Required ];
Name of schema that contains the foreign server for this table
Property methods: SERVERSCHEMADisplayToLogical(), SERVERSCHEMAGet(), SERVERSCHEMAIsValid(), SERVERSCHEMALogicalToDisplay(), SERVERSCHEMALogicalToOdbc(), SERVERSCHEMANormalize(), SERVERSCHEMASet()
property TABLENAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = TABLE_NAME , Required ];
Name of the foreign table.
Property methods: TABLENAMEDisplayToLogical(), TABLENAMEGet(), TABLENAMEIsValid(), TABLENAMELogicalToDisplay(), TABLENAMELogicalToOdbc(), TABLENAMENormalize(), TABLENAMESet()
property TABLESCHEMA as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = TABLE_SCHEMA , Required ];
Name of schema that contains the foreign table.
Property methods: TABLESCHEMADisplayToLogical(), TABLESCHEMAGet(), TABLESCHEMAIsValid(), TABLESCHEMALogicalToDisplay(), TABLESCHEMALogicalToOdbc(), TABLESCHEMANormalize(), TABLESCHEMASet()
property UsingString as %String (MAXLEN = 3200) [ Calculated , SqlFieldName = USING ];
Property methods: UsingStringCompute(), UsingStringDisplayToLogical(), UsingStringGet(), UsingStringIsValid(), UsingStringLogicalToDisplay(), UsingStringLogicalToOdbc(), UsingStringNormalize(), UsingStringSQLCompute()

Foreign Keys

foreignkey (ServerSchemaExact,ServerNameExact) references INFORMATION.SCHEMA.FOREIGNSERVERS [OnDelete=noaction, OnUpdate=noaction];

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: SQLStorage

Maps: 1

  • Map number 1 is named Master

    thismap.Global: ^rINDEXSQL

  • ^rINDEXSQL("SERVER",{ServerSchemaExact},{ServerNameExact},1,{FullTableExact})
    =
    Node Delimiter Piece Name
    TABLE_SCHEMA
FeedbackOpens in a new tab