As part of processing an Invoice, our 3rd party ERP creates, queries, then drops a view on one of the ERP Database tables.
We have separate concerns about this, but I'm genuinely curious: do either of the CREATE or DROP statements require a Schema Modification Lock on the Database or the tables that are involved in the view?
If not, are there any other lock types involved in the process that we should be concerned about?