We execute SQL Statements through ADO in our C++ Applications.
In one of the queries, I need to check if there is any data in the table, and if not drop the table and recreate it based on the user's new definition . If data exists, then the application will not do anything.
Does anybody know how to do this. In SQL Server, we used to use "IF exists" to do this.