You can list all the database tables by issuing a simple SQL command:

SELECT * FROM INFORMATION_SCHEMA.TABLES

You can then loop through the resulting rows and search for the given table names or just add a WHERE condition.

Hi@all

I've also one question to this problem I've to get solved very urgent.

Could you please post the whole codesample for the problem posted by dana?

I am too new to vb.net, sorry

I want to check for an existing tbl called tbl_inventory for my application. This should be dropped if it exists and then it should be recreated.

Heres my Codesample, that doesn´t work, and I don´t know why. On the Windowsapplication I tested the same codesample and it worked perfectly.

Please help me

createtable = "IF EXISTS (SELECT * FROM pocket_invis2.sdf WHERE object_id=object_id(N'[tbl_inventory]') " & _

" AND TYPE IN (N'U')) DROP TABLE [tbl_inventory]" & _

" INSERT INTO tbl_inventory (barcodeID, element, new_barcode, new_element) " & _

" SELECT computerID, 1 AS computername, NULL, NULL FROM tbl_computer " & _

" UNION " & _

" SELECT deviceID, 0 AS devicenameID, NULL, NULL FROM tbl_device "

Hi dana

Thanks for you reply

After long testing, I found a way too. It seems that, the if exists, doesn't exist on the mobile sql.

I made it with a datareader to loop through the tablenames and then drop or create the table.

best regards

Hannes

Why you guys are going for such complex logic. Call DROP TABLE and handle TABLE DOES NOT EXIST error.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Server Everywhere, Microsoft Corp.