开发者

Possible to hide columns in a SQL Server Management Studio database diagram?

开发者 https://www.devze.com 2022-12-20 23:16 出处:网络
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 no

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号