Is there a way to disable / disallow someone from using View Creator using Diagram Tool in SQL Server? We have a lot of DB and BI analysts who regularly create views. Some folks create these views using SSMS' view creator which allows someone to drag and drop tables. This creates a lot of problems when we need to review or modify their code as the diagram tool in SSMS messes up the indentations and formatting, making it impossible to review the code. Is there an option or permission that I can revoke/change that disallows everyone from using it?
The view designer comes with SSMS and cannot be managed by any database engine. So, you can completely block them from creating views with DENY permission (as long as they are not sysadmin role members), but you cannot restrict them using SSMS features as the features installed in their local PC:
DENY create view to ApplicationUser