>I need to check (from a VFP 9 application) if a table in the SQL Server DB exists. I found a pretty simple code in one of the online threads. The code is as follows:
UPDATE: UGH: my fault.....I didn't realize you were talking about VFP....my fault....I'd delete my answer but I don't think I can delete a post. Sorry about that.
Which version of SQL Server are you using?
For instance, there's an IF EXISTS that's tied to the DROP TABLE statement in SQL 2016
DROP TABLE IF EXISTS dbo.MyTable