Skip to main content
Skip table of contents

formatTableName

You are looking at an older version of the documentation. The latest version is found here.

This procedure quotes the fully qualified name of a table or procedure, checks if it exists in the system metadata, adjusts the name casing, and optionally throws an error if the object does not exist (this may be helpful if this is a source table/procedure).

Parameters

ParameterDescription
tableNameTable/procedure name, requires a fully-qualified object name. The name will be quoted using the specified casing if the object does not exist. If it exists, the casing will be adjusted accordingly; mandatory
tableDescriptionText description of the object. Used in error messages only to distinguish the object for convenience
checkExistsIf set to TRUE, the procedure will fail with an error in case the object does not exist
isTableWhether the object is a table or a procedure; default: TRUE

Usage

SQL
CALL UTILS.formatTableName(
    tableName => 'datasource.tablename',
    tableDescription => 'target',
    checkExists => TRUE,
	isTable => TRUE  
);;
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.