Where can I find the SQL Server Persistence Database table description for .NET 4.0 or 4.5? I can find the following:
Workflow Tracking Service Database
But this is specific to 3.5, and I know the structure has changed in .Net 4. I also found this document, but it only describes the views, not the tables created.
You'll find the files installed under
C:\Windows\Microsoft.NET\Framework\v4.0.30319\SQL\en
I believe the files needed for WF4 are
SqlWorkflowInstanceStoreSchema.sql
and
SqlWorkflowInstanceStoreLogic.sql
It isn't clear which are WF3 and which are WF4, but you can usually figure it out as WF4 table names are all [System.Activities.DurableInstancing].[SomethingHere]. So if you're not sure about a file, crack it open and look for that namespace-style name.
In working with Microsoft Support I received this answer below, which is definitely not ideal, as it only really describes the views. I will update if I get a better response from them.
It looks like the database schema details is internal only and not available to public. Only public documentation is here:
http://msdn.microsoft.com/en-us/library/ee943755(v=vs.110).aspx
Documentation on DB scripts is here:
http://blogs.msdn.com/b/carlos/archive/2013/01/10/workflow-foundation-sql-scripts.aspx
