Home Forums SQL Server 2012 SQL Server 2012 - T-SQL tsql to get table name from a regular dml query RE: tsql to get table name from a regular dml query
Joe Torre
SSChampion
Points: 10248
More actions
March 20, 2017 at 5:38 pm
#1934101
I think what you want is something like:IF EXISTS(SELECT * FROM sys.tables WHERE name = 'Orders') SELECT * FROM Orders;
IF EXISTS(SELECT * FROM sys.tables WHERE name = 'Orders') SELECT * FROM Orders;