ADMIN_SplitTableNames

 Show all Hide all

Deprecated.

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

Parameters:

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

Resultsets:

Resultset: Table information

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

Columns:

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