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
 
Top