[Bug]: Allow drop non-empty external catalogs

[link3280]

Search before asking

• I have searched in the issues and found no similar issues.

What would you like to be improved?

Currently, it's forbidden to remove a non-empty catalog if a catalog has managed tables. However, the implementation actually checks all tables, not only the managed ones. As a result, external catalogs can never be removed.

amoro/ams/server/src/main/java/com/netease/arctic/server/table/DefaultTableService.java

Lines 233 to 237 in 84e095b

	public List<ServerTableIdentifier> listManagedTables(String catalogName) {
	checkStarted();
	return getAs(
	TableMetaMapper.class, mapper -> mapper.selectTableIdentifiersByCatalog(catalogName));
	}

How should we improve?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Subtasks

No response

Code of Conduct

• I agree to follow this project's Code of Conduct