All of my tables have certain audit columns (CreateDate,CreateBy,UpdateDate,UpdateBy)
Since t开发者_运维知识库hey just take up visual space, is it possible to somehow hide these columns so they do not show up in a database diagram in SSMS or SSMSE?
Actually you can. Just right click on the table and select the "Table View" from the context menu.
Unfortunately, no.
You can show or hide whole tables only. Or resize. or reverse engineer into Visio or some such tool
Edit, Dec 2017
"Table View" in diagrams show all columns or no columns. It does not remove some columns
Yes, you can modify the view of column attributes but OP did not ask this.
Read the question please
You have to select all tables (ctrl+a) then select Table View > Name Only.
You can create views selecting only the columns you want to see in the diagram, then you use those views in the diagram instead of using the original tables.
Perhaps those views could be use by the application itself.
精彩评论