RaigorJiang opened a new issue #14612: URL: https://github.com/apache/shardingsphere/issues/14612
Hi community, this issue is similar to [SHOW UNUSED SHARDING ALGORITHMS](https://github.com/apache/shardingsphere/issues/14609), we want to add a DIstSQL to help users find unused resources. ### Background 1. The user added a resource, but never used it; 2. The user has altered the rules and released the previously used resources, but has not yet dropped them; > Note: If there are single tables on the resource added by the user, this resource is recognized as in used and will not appear in the result set of `SHOW UNUSED RESOURCES`. ### Aim The syntax is as follows: ```sql SHOW UNUSED RESOURCES [FROM schemaName] ``` ### Reference - [RDL](https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rdl/resource-definition/) - [RQL](https://shardingsphere.apache.org/document/current/en/user-manual/shardingsphere-proxy/distsql/syntax/rql/resource-query/) - `DropResourceBackendHandler` for `DROP RESOURCE` DistSQL - `DataSourceQueryResultSet` for `SHOW SCHEMA RESOURCES` DistSQL -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
