Parsename function in sql server

 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.