By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,091 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

delete a table in an external database

P: n/a
hi NG

I have got a database, and from this database I want to delete a table in
another database, before Iexport a new table to that other database.

My question is how can I delete a table in a forein database?

Thx in advance
Tony
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Tony wrote:
hi NG

I have got a database, and from this database I want to delete a table in
another database, before Iexport a new table to that other database.

My question is how can I delete a table in a forein database?


air code:

dim db as database
set db=opendatabase(yourwhatever)
db.execute "drop table yourtable"
db.close
set db=nothing

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #2

P: n/a
I would probably simply use

DROP TABLE [External_DB_Path_and_Filename].Tablename

in an action query or code. No need for opening connections explicitly.
Pavel

Bas Cost Budde wrote:

Tony wrote:
hi NG

I have got a database, and from this database I want to delete a table in
another database, before Iexport a new table to that other database.

My question is how can I delete a table in a forein database?


air code:

dim db as database
set db=opendatabase(yourwhatever)
db.execute "drop table yourtable"
db.close
set db=nothing

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #3

P: n/a
Pavel Romashkin wrote:
I would probably simply use

DROP TABLE [External_DB_Path_and_Filename].Tablename


Interesting! Does CREATE TABLE do that, too?

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #4

P: n/a
It does. Give it a shot.
In fact, if you use QBE to create a table in external DB, this is kind
of SQL you see in the SQL view.

Pavel

Bas Cost Budde wrote:

Pavel Romashkin wrote:
I would probably simply use

DROP TABLE [External_DB_Path_and_Filename].Tablename


Interesting! Does CREATE TABLE do that, too?

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #5

P: n/a
Thx a lot guys

"Pavel Romashkin" <pa*************@hotmail.com> skrev i en meddelelse
news:40***************@hotmail.com...
It does. Give it a shot.
In fact, if you use QBE to create a table in external DB, this is kind
of SQL you see in the SQL view.

Pavel

Bas Cost Budde wrote:

Pavel Romashkin wrote:
I would probably simply use

DROP TABLE [External_DB_Path_and_Filename].Tablename


Interesting! Does CREATE TABLE do that, too?

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.