Wednesday, 28 August 2013

How to get table/view name (i.e. remove schema prefix)

How to get table/view name (i.e. remove schema prefix)

Given one of the following strings (which represent a table/view name in
SQL Server):
var x = "my-Table.request";
var x = "[my-Table.request]";
var x = "dbo.my-Table.request";
var x = "[dbo].[my-Table.request]";
var x = "[dbo].my-Table.request";
var x = "dbo.[my-Table.request]";
I would like to get the table name: my-Table.request
Any ideas?

No comments:

Post a Comment