PARSENAME#
Returns the specified part of an object name. The parts of an object that can be retrieved are the object name, owner name, database name, and server name.
Syntax#
PARSENAME ( 'object_name', object_piece )
Arguments#
‘object_name’
Is the name of the object for which to retrieve the specified object part. object_name is sysname. This parameter is an optionally-qualified object name. If all parts of the object name are qualified, this name can have four parts: the server name, the database name, the owner name, and the object name.
object_piece
Is the object part to return. object_piece is of type int, and can have these values:
Value |
Meaning |
|---|---|
1 |
Object name |
2 |
Schema name |
3 |
Database name |
4 |
Server name |
Return types#
nvarchar
Example#
SELECT PARSENAME('AdventureWorks2012..Person', 3) AS 'Database Name';