Is there any sort of entity relationship diagram or list of tables for the Forms database? We have occasion to build some custom reports and need to build other queries based on the tables.
Hello Rob,
You can view a list of all the tables in your Forms database in SQL Server Management Studio. Just expand the ServerName node, then the 'Databases' node, then the node for you Forms database. Expand the 'Tables' folder to see a list of all the tables in that database.
Also, you should see a 'Database Diagrams' node above the 'Tables' node in your Forms database. You can right-click this folder and select 'New Database Diagram'. This will open a dialog allowing you to select all the tables you wish to include in the diagram. Scroll to the bottom, hold the 'Shift' button down on the keyboard, click the last table in the list, and then click the 'Add' button. This might take a minute or two depending on your server specs, but afterward you will have a diagram of all the tables in the database and their relationships.
I hope this helps!
~Rob
There is no such documentation. What version of Forms do you refer to? I can check whether I can provide such information to you.