You are viewing limited content. For full access, please sign in.

Question

Question

Forms Database Tables Documentation

asked on May 3, 2017

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.

3 0

Replies

replied on May 4, 2017

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

3 0
replied on May 3, 2017

There is no such documentation.  What version of Forms do you refer to? I can check whether I can provide such information to you.

0 0
replied on May 4, 2017

We are running 10.2.  Thanks for any info that you can provide.

0 0
replied on June 21, 2018

Does Laserfiche plan to investing time/resources  to public a table-relationship diagram for LF Forms in the near future? This would be very beneficial to your clients.

6 0
You are not allowed to follow up in this post.

Sign in to reply to this post.