PARSE_NAME_UDF

Description

Returns the specified part of an object name. The parts of an object that can be retrieved are the object name, schema name, database name, and server name. (SQLServer documentation)

SQLServer syntax

PARSENAME ('object_name' , object_piece )

Custom UDF overloads

Parameters

1. STR: A varchar expression that is being evaluated over the parts that can be retrieved.

2. PART_NUMBER: An int expression that specifies the part of an object name.

UDF

CREATE OR REPLACE FUNCTION PARSE_NAME_UDF(STR VARCHAR, PART_NUMBER INT)
RETURNS VARCHAR
LANGUAGE SQL
IMMUTABLE
AS
$$
  SELECT SPLIT_PART(STR,'.', -1 * PART_NUMBER)
$$;

SQL Server

Query

SELECT PARSENAME('TEST.TEST.TABLETEST', 1);

Result

TABLETEST

Snowflake

Query

SELECT
--** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'PARSE_NAME_UDF' INSERTED. **
PARSE_NAME_UDF('TEST.TEST.TABLETEST', 1);

Result

PARSE_NAME_UDF('TEST.TEST.TABLETEST', 1)
TABLETEST

Related EWIs

1. MSCEWI1020: CUSTOM UDF INSERTED.