469,354 Members | 2,046 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,354 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
5 13716
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
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.