Show all Hide all


Splits a delimited list of table names and looks up their complete name and object id.

Type: Table-valued function
Area of use: General use


@Delimiter mandatory varchar(100)
Delimiter between table names
@TableString mandatory text
List of tables


Resultset: Table information

Repeat mode: repeated exactly once
Row count: zero or more rows


fullname optional sysname
Full name, i.e. [owner].[name]
name optional sysname
Table name
objectid optional int
Sql Server object id for the table
ordinal optional int
Order in the input string
owner optional sysname
Table owner