Chris Collinson
UK
Member
Members
Forum Posts: 7
Member Since:
March 7, 2014
March 7, 2014
Offline
I have recently been asked to create a load of reports using data from our ERP system. In order to get an understanding of which tables to use to get the required data from, it would be really useful to create a table in excel that shows a list of all the tables in the database with all the fields in each table.
There are nearly 1000 tables in the database so before I start to create the table manually I was wondering if there was a way that I can get PQ to do it for me.
Mynda Treacy
Admin
Forum Posts: 4696
Member Since:
July 16, 2010
July 16, 2010
Offline
Hi Chris,
Maybe the Table.Schema function will help as described here: https://blog.crossjoin.co.uk/2.....power-bim/
Mynda
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Cassie Bernier
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1914
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Brenda Wolf
ABUBAKR BABHAIR
Mallika Asireddy
Sheila Sanders
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Forum Stats:
Groups: 3
Forums: 24
Topics: 6836
Posts: 29990
Member Stats:
Guest Posters: 49
Members: 33570
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —