What is the best way to find a database schema that lays out every table and field in Epicor?

If you’re looking for Epicor-provided system information, I would take a look at the data dictionary form which should be within the system maintenance menu.

Is there a table to do a sql query lookup of all the tables and fields?

It sounds like you want to execute this general SQL after selecting your Epicor database: SELECT o.name AS tbl, c.name AS col, t.name AS type, t.max_length AS size FROM sys.objects AS o INNER JOIN sys.columns AS c ON o.object_id = c.object_id INNER JOIN sys.types AS t ON c.system_type_id = t.sy…

Also, this is a good article [image] sys.columns (Transact-SQL) - SQL Server sys.columns (Transact-SQL)

Did you take a look at this? [image] Table relationship diagram Yahoo Archive What version are you on? I just notices today that the Pack slip RDD (which drives the labels too) involves 25 tables. Blew me away. Just for tha…

Is there a field description column that can be included in the sql query?

zdatafield.dbtablename, zdatafield.dbfieldname,zdatafield.description contains most of what you are looking for.

I was waiting until I got home to post what @aidacra just posted. This is the Epicor listing of the tables and fields as organized by the application.

I stopped using the Data Dictionary for quite a while, it is just inconvenient There’s probably one from old yahoo group, generated by HtmlDict, like this but at E905 http://epidd.wisconsinconverting.com/ It doesn’t have graphs or ER diagram, but at least you can see descriptions, and a list of t…

I actually created a dashboard from a query that utilizes the “zDataTable” and “zDataField” tables along with a tracker Matches(*) criteria fields on the table/field name/description. These tables list out all of the tables and field located in the database. These are the fields that I utilize in th…

Database schema - Table and fields

Epicor ERP 9

danbedwards (Dan Edwards) April 25, 2018, 9:18pm 6

Did you take a look at this?

Topic		Replies	Views
Display Epicor Tables data and identify with tables an entry is using Epicor ERP 10 e10	2	886	November 27, 2023
Table & field lookup Epicor ERP 10 table , field	3	2259	March 1, 2024
Epicor 10 SQL Database Schema available? Epicor ERP 10	7	13539	January 28, 2019
Database Schema for E10 Epicor ERP 10	28	15456	May 7, 2024
Database schema reporting Epicor ERP 10 e10 , sql , reports	5	1376	July 17, 2019

Database schema - Table and fields

Related topics