Hi Experts,

I have a workspace created and associated a metastore with it, the metastore points to a storage location USDATA and then I create two catalogs in the workspace and one is using default meta store as the external storage location and other catalog is sales and i created a external sales storage location and provided security access. 

Abive screen shot  says storage for managed tables on external locations, so now my question is if i create a table in the sales catalog without  specifiying any external location, will the tables created be managed and will go to the Sales storage account and in the event of deleting the table ,will it delete the files associated as welland auto optimize? What will my metastore USDATA  have information about the sales catalog , if the sales catalog had a seperate storage location , its the metadata about the catalog goes to metastore?