Its Return Part of an Object Name in SQL Server. We know we are writing the SQL server full qualifier name in the four parts. A full qualifier name is denoted in four parts [Server Name].[Database Name].[Schema Name].[Database object Name]. With the help of Parsename function, we can easily server, schema, database, and table name.
Syntax of
this function
PARSENAME
(‘object_name’, object_piece)
Where object_name is
the (optionally-qualified) object name and object_piece is the part
that you want returned.
The object_piece argument
must be an int between 1 and 4. The value determines which part of
the object name to return. These values correspond to the object part as
follows:
|
Value |
Object
Part |
|
1 |
Object name |
|
2 |
Schema name |
|
3 |
Database name |
|
4 |
Server name |
Let's see the example
|
DECLARE @object_name
char(50) = 'BAGESH-PC.dbo.Test.Emp_Stg'; SELECT
PARSENAME(@object_name, 4) AS [Server],
PARSENAME(@object_name, 3) AS [Schema],
PARSENAME(@object_name, 2) AS [Database],
PARSENAME(@object_name, 1) AS [Object]; |
Got the expected result.
