Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
 Posted - 2007-05-31 : 16:20:49
|
| can i add views in a DB diagram using Enterprise Manager.I know I can add tables but is there a way to add views.Ashley Rhodes |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2007-05-31 : 16:44:49
|
| No unfortunately not, only tables can be added.If the goal is to be able to create a diagram for documentation or display purposes:Temporarily for creating the diagram you may do aselect * into vMyview from MyView where 1=0 -- create "fake" table mimicking the view just for diagramming purposes.But it is kind of a hack.You may create a new database with only empty tables just for this purpose.rockmoose |
 |
|
|
|
|
|
can i add views in a DB diag using Enterprise Mngr