SQL DDL from ERD Diagram

P

Philipp Post

Good day,

I am creating a SQL DDL script file form a Visio 2003 Entity
Relationship Diagram. When looping through the shapes, i. e.
IEnumIVMEModelElements I am checking for the database tables by
looking for vis_shape.Type = eVMEKindEREntity, but this also puts out
the VIEWs created, although they should be represented as
eVMEKindERView as far as I understand it.

How can I differentiate between TABLEs (entity shapes) and VIEWs (view
shapes)?

Thanks n brgds

Philipp Post
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export ERD to SQL Server 17
Cannot export Visio 2007 ERD to SQL Server database 2
Forward Engineer Visio ER Diagram to SQL DDL 2
tables dropped from ERD diagram also get dropped from "tables andviews" 1
generating sql script from diagram 1
Excel style add-ins in Visio 1
can't delete table shapes from an ERD without loosing base tables 0
ReverseEngineer\Visio2007Pro 0

Top