Primary Key vs Unique Key What's the difference between primary keys and unique keys? Learn how to define a unique key, how to use the key for relationships and more. Generating Synchronization SQL Scripts for MariaDB Learn how to compare MariaDB schema and generate synchronization SQL scripts for changes detected by Luna Modeler - a database design tool. MariaDB database design Luna Modeler - a tool for MariaDB database design. See how to visually create database design for MariaDB and how to generate SQL scripts. Primary and foreign keys in MariaDB projects How to define primary keys, foreign keys and primary foreign keys in Luna Modeler, a tool for database design for MariaDB and other platforms MariaDB indexes How to create indexes in Luna Modeler - data modeling tool for MariaDB, PostgreSQL, SQL Server and other relational databases. Visualization of existing MariaDB databases Connect to a MariaDB database and reverse engineer your existing database structures. Visualize databases and create ER diagrams. Generating SQL script for MariaDB How to generate SQL scripts for MariaDB database design in Luna Modeler - a data modeling tool for MariaDB and other databases. Other database objects in MariaDB projects How to define other database objects like stored procedures, functions, triggers and other MariaDB specific objects in Luna Modeler Enum and Set in MariaDB projects Enum and Set datatypes defined for MariaDB in Luna Modeler - a data modeling tool for MariaDB, PostgreSQL and other databases. Relationships in ER diagrams for MariaDB Database modeling and relationships defined in Luna modeler - a tool for visual database modeling for MariaDB and other databases. Advanced Copy and Paste in Luna Modeler See how to copy and paste one or more tables or individual columns in your ERD. Find out how to work with dependencies in Luna Modeler. Relationships in ER diagrams for PostgreSQL Learn how to define relationships in ER diagrams for PostgreSQL and find out how to use Luna modeler - a database modeling for PostgreSQL Updating MariaDB projects Read how to create a new database connection and update your existing MariaDB ER Diagram created in Luna Modeler - a database design tool. Primary Key vs Foreign Key What's the difference between primary keys and foreign keys? Learn how to define a primary key, a foreign key, and how to visualize JSON.
