Validations around object name compared to the file name and object in file content

[shantstepanian]

• Do the comparison of object name from the file name vs. file content (e.g. checking the create view statement)
• Checking the file name if it is multipart and the schema name matches, which could hint at the name being incorrect

This is to avoid issue where a schema is accidentally considered an object name and causes a cascading drop issue in a deploy