Working with databases

copy link

Introduction

This chapter describes the operations that can be run on databases: creating tables, fields, foreign keys, etc.

Introduction	In this tutorial we'll see what will be presented in the group of lessons in this section.
Creating a project	In this tutorial we'll see how to create an Instant Developer Foundation project.
Creating a Microsoft SQL Server database object	In this tutorial we'll see how to create a database in Microsoft SQL Server.
Creating a MySQL database object	In this tutorial we'll see how to create a database inside MySQL.
Creating a table object	In this tutorial we'll see how to create a table in a database.
Creating a field object	In this tutorial we'll see how to create a field inside a table.
Creating a foreign key field object	In this tutorial we will look at how to create a foreign key between two tables.
Database graphic	In this tutorial we'll see how to display the graphic of the relationships between tables in the database.
Assigning the Binary Values value list	In this tutorial we'll see how to create a boolean type field.
Creating a customized value list	In this tutorial we'll see how to create a customized value list to associate with a field in a table.
Creating a domain	In this tutorial we'll see how to use Instant Developer Foundation domains to define the database table fields.
Physical creation of a database structure	In this tutorial we'll see how to create the structure of the tables on the database in Instant Developer Foundation.
Analysis of the ZZ_OBJECTS table	In this tutorial we'll see what the ZZ_OBJECTS table is, and how Instant Developer Foundation uses it.
Importing the structure of an existing database	In this tutorial we'll see how to import the structure of an existing database managed outside of Instant Developer Foundation.
Creating database views	In this tutorial we'll see how you can create views of tables in a database.
Updating the physical database structure	In this tutorial we'll see how to update the structure of the database.
Summary	This tutorial will summarize what we have learned in the Working with databases group lessons.

Changed on: 17/11/2023 / From version: 20.0.7800