{"version":"1.0","type":"rich","title":"Simple database","description":"This example shows how to create a simple relational database with two tables, Customers and Orders, using raw SQL. It demonstrates the use of IDENTITY columns for auto-generated primary keys and FOREIGN KEY constraints to enforce referential integrity between the tables. The code also includes a JOIN query that combines customer names with their corresponding order details, illustrating basic data retrieval without an ORM. The example relies on standard SQL Server syntax and T-SQL commands, including CREATE TABLE, CONSTRAINT, and SELECT with JOIN.","provider_name":"VizHub AI Studio","provider_url":"https://next.vizhub.com","html":"<iframe src=\"https://next.vizhub.com/viz/gist-7dea1c666af2bd606b014b48fcfe6dc4?mode=embed\" width=\"960\" height=\"500\" scrolling=\"no\" frameborder=\"1\"></iframe>","width":960,"height":500,"cache_age":3600}