INtools Forum

Forum Home

Aggregated

FAQ

Admin Module

no of tables...

no of tables

11/13/2007 4:13:12 AM

mahesh_borole

12 posts

no of tables

hi i mahesh i want to kanow the number of the tables in the spi and where i will get this .how the table structure is interlinked in spi

i also want to know the number of macros in specific module

11/13/2007 7:10:50 AM

fba_sen57

73 posts

www.shell.com

Re: no of tables

Hi mahesh... In Brunei Shell, we are still using INtools version 6. If you run the sql below, will it not get you the table. Or perhaps, you may want from vendor (Intergraph) to send you the ERD (Entity Relationship Drawing) for SPI 7.

select * from table_list;

11/13/2007 11:32:19 AM

admin

178 posts

Re: no of tables

The ERD supply in the original Intools(SPI) documentation.

Select * from table list not provide all the tables in intools same with ERD.

You can ask from Integraph the document call Data Dictionary.

Ilan Hills ihills@asbuilt-dba.com www.asbuilt-dba.com

Page 1 of 1

Aggregated

FAQ

Admin Module

no of tables...