Database schema reporting

[kmailloux (Keith Mailloux)]

I need to obtain a list of field names and associated tables in the erp db. Anyone have a simple method they could share. It has been a long time since I’ve messed with SQL Server manager.

Thanks

Keith

[Mark_Wonsil]

For the love of all that is holy, please tell me you’re in a test environment.

@hkeric.wci did all the hard work for us:

[ Download ] Epicor 10.2 & Kinetic .CHM Schema

We have taken the time to generate a brand new Schema .chm for easier researching, and would like to offer the file to you. It is for educational purposes, not to be sold. It is current as of 10.2.300.2: I find doing research in it I find column details, all tables that contain the column etc… its my #sidekick always open and its extremely convenient and efficient. You can also use *wildcard. In any page you can use CTRL+F to prompt a search window, and easily find a word in a desc like “Cost” …

Friends don’t let friends SSMS in their Epicor Live databases.

[kmailloux (Keith Mailloux)]

Thanks Mark, just what I was looking for, thanks also @hkeric.wci. When I try to view the file the table list displays fine but the detail portion is blank. Do I have a setting issue. Lord knows I have issues……

Keith

[tsmith (Tyler Smith)]

You probably have to tell Windows you trust the file. Go to file properties and select “Unblock”:

[kmailloux (Keith Mailloux)]

Tyler, you are correct. I always forget that part.

Thanks for posting.

[hkeric.wci (Haso Keric)]

Nice @tsmith I didnt know there was an option like that.