I need to determine whether a table in a AS400 linked server exists before I attempt to select from the table. I need the equivalent of the code below that is written for a SQL Server linked server.
Thanks.
Code:
IF EXISTS(SELECT 1 FROM myDatabase..sysobjects WHERE name = ''myTable_@date'' AND xtype = ''U'')
Thanks.