>>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
I am using SQL Server 2008 but customers use everything from 2008 to 2017.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham