SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships.

Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.

Creating and using an SQLite database for data persistence in Android apps. Covers the basics, as well as using foreign keys. Full source included.

You can create a table from a query using the SQL Editor window or the Query window. In all operating environments, you can create SAS tables and views. In OS/390, you can also create DB2 tables. In ...

A developer shouldn't spend time on database table creation when unit tests run. Instead, have Hibernate create tables in the database for JPA and other data-driven applications.