Hello,

I am trying to find some type of script to delete a table that I created on a remote SQL server. I only have MS Access and I know it is possible to create an Access table, export it, and then link it back to the Remote SQL database. The info inside can be updated, but if I need to change the table, you cannot do that through access.

I figure if I can delete the table, and then export the reformatted table, this is essentially the same thing. I am not concerned with the information in the table (i.e. the records) the table ASP pages I am writing are still in development.

Thank you for you help,

-Darren

Im guessing you can use the SQL:
DROP TABLE <table_name>;

in an ADODB.Command

you can also use:
ALTER TABLE <table_name>
ADD <column_name> <column_type>

or to delete a cloumn:
ALTER TABLE <table_name>
DROP COLUMN <column_name>

I suggest purchasing a copy of teach yourself SQL in ten minutes. Its been a godsend for me. Or you could probably check the MYSQL documentation (i think chapter six details all the SQL commands you will ever need, but i find it quite hard to read)