Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

All of my tables have certain audit columns (CreateDate,CreateBy,UpdateDate,UpdateBy)

Since they 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?

like image 493
tbone Avatar asked Feb 24 '10 17:02

tbone


2 Answers

Actually you can. Just right click on the table and select the "Table View" from the context menu.

like image 140
Vasil Trifonov Avatar answered Sep 19 '22 07:09

Vasil Trifonov


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

like image 25
gbn Avatar answered Sep 18 '22 07:09

gbn