Is it possible to delete a table from a database using vbcode?

[shahina]

Hi....

i want to delete a particular table if it exists..i know how to check if there is a table exist..is there a way to delete the table if it exists...

thanks in advance...

with regards,
shahina.

 

[LordGarfield]

well check if the table excists and then use the sql drop table <tablename>.

tank you,

(>" "<)
(='o'=)
-(,,)-(,,)------------------------------
LORD_GARFIELD
---------------------------------------

 

[shahina]

Sir,

thank u LordGarfield...can u tell me how to use the sql code? i tried using 'recordset.open "DROP TABLE tablename, myconnection'
but i am getting the error saying the drop table syntax is not correct..
please help me..

with regards,
shahina

 

[johnwm]

You can use ADOX. Add a reference to Microsoft ADO Ext 2.7 for DDL and Security.

Object Browser will then show the Tables collection has a Delete method.

VBHelp shows an example of it's use

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

 

[petermeachem]

You could just do

on error resume next
myconnection.execute "DROP TABLE tablename"

This saves checking if the thing exists first. Put it in a sub then it won't affect any other on error you have.

http://www.accuflight.com

http://www.lettersdirect.co.uk

http://www.ourhouseinportugal.co.uk/