Wednesday, March 28, 2012

No info in diagramed tables

I ran the diagram tool in EM SQL 7.0 and the table appears but nothing else is visible. If you check properties everything is grayed out. Select tables with Joins and all the tables show but again no column names, key or joins visible. I opened the diagram in Northwind and it appears correctly. I must have missed something, hope someone knows what.

Thanks in advance.
KayteeHOriginally posted by Kayteeh
I ran the diagram tool in EM SQL 7.0 and the table appears but nothing else is visible. If you check properties everything is grayed out. Select tables with Joins and all the tables show but again no column names, key or joins visible. I opened the diagram in Northwind and it appears correctly. I must have missed something, hope someone knows what.

Thanks in advance.
KayteeH

Can you right click on the table and get a menu that has an option called table view?|||could it be that you're missing permissions?|||Originally posted by Brett Kaiser
Can you right click on the table and get a menu that has an option called table view?

No - I don't see a menu that says table view.|||Originally posted by ms_sql_dba
could it be that you're missing permissions?

That's what I thought, but I am dbo. I can use the diagram feature in other databases I own. Just not this particular database.

No comments:

Post a Comment