Working with databases
copy linkIntroduction
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