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