How to drop a table if exists in a SQL Script CE

[B_Hodge]

Can any body tell me that how can to drop a table if exists in a SQL Server CE. Can any body tell me that how can i do so? Does any body knows about it? Kindly provide me the correct solution for teh above issue. Any kind of information on the above issue would be appreciated.

[Praetor]

You can try out the following code:-

select count(*) from information_schema.tables where table_name='Action'

if the result is > 0, that means the table exists.

[kelfro]

In order to test the existence of a given table in SQL Compact, you have to query the INFORMATION_SCHEMA.TABLES view, something like:

SELECT * FROM INFORMATION_SCHEMA.TABLES

Look for the table name in the TABLE_NAME column. For that you can also use the table name in a WHERE clause, like:

SELECT COUNT(TABLE_NAME) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'table name to test'

Hope so it may help you out.