CODEWITHSUNDEEP
sqlh2
user41010
user41010

Reputation: 101

How to close linked table in H2db?

Is there a syntax to close a table link? In other words, what is the opposite of create linked table LocalTableToBe( className, url, userName, password, RemoteTableSource )?

Upvotes: 1

Views: 42

Answers (1)

Evgenij Ryazanov
Evgenij Ryazanov

Reputation: 8188

You can only drop these table links with the regular DROP TABLE command:

DROP TABLE LocalTableToBe;

This command drops the specified link, the actual table in another database isn't affected by it.

Upvotes: 1

Related Questions