467,105 Members | 1,018 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,105 developers. It's quick & easy.

delete a table in an external database

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
  • viewed: 13424
Share:
5 Replies
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
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
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
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
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.

Similar topics

2 posts views Thread by Scott | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.