[FEATURE] Add delete schema cascade as option which can be enabled

[shkelzeen]

Problem Statement
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
We use the SDK to do most of the management calls with it, one of these calls is to create and delete schema when deleting schemas it failed because of the not empty schema (has tables) and there is the option to cascade this we just need to add this connection

Proposed Solution
A clear and concise description of what you want to happen.

Add a flag on the DeleteSchemaRequest which allows it to delete the schemas with a cascade flag which will allow you to delete not empty schemas

Additional Context
Add any other context, references or screenshots about the feature request here.