database tables search in vb.net
-
Sir/Madam, Can I programically find out whether the particular table exist in the database or not. My database is MS-Access I am trying to find the table constructed in the database. Thanks abd Regards Pankaj
just try this SELECT * FROM MSysObjects
solidIT.de - under construction Components for Microsoft .Net audittrail, objectcomparer, deepcopy and much more ...
-
just try this SELECT * FROM MSysObjects
solidIT.de - under construction Components for Microsoft .Net audittrail, objectcomparer, deepcopy and much more ...
-
Sir/madam, Thanks for ur kind attention.But how i will get to know that whether that table exist or not. Thanks and Regards
no prob SELECT COUNT(*) AS TABLE_EXISTS FROM MSysObjects WHERE Name = 'Forms' - and now you only have to replace "Forms" in the where clause with the table you want to check - if the TABLE_EXISTS field is bigger than 0 (zero) then the table exists otherwise it doesn't
solidIT.de - under construction Components for Microsoft .Net audittrail, objectcomparer, deepcopy and much more ...