access from another database

[sugan]

i am currently working in one database. I just want to know how to access (select or delete) other database table from my current database.Is there any possibility of doing that?Regards.Sugan

[justsomeguy]

You didn't say which database you're using or how you're using it, but most databases allow some sort of dot notation to refer to a database and table name. Check the documentation for the database you're using to see how to reference a database and table name together. Depending on how you're connecting to the database you might not be able to do what you want.

[Synook]

E.g. (in MySQL) selecting a table mytable from a different database anotherdb

SELECT * FROM anotherdb.mytable