Using the SQL Schema Editor
A schema is the structure in the form of tables in which the data is stored. You use the Schema Editor to edit the table definitions and the data contained in the tables.
Data Access provides you with a simple schema editor to allow you to immediately get started with the example in this tutorial or for other uses. You can, of course, use your DBMS schema editing tools if you prefer.
Warning: Use the SQL Schema Editor only in the design phase of your database. If you use the SQL Schema Editor for tables that contain data, this data will be lost when you export the table definition. To change the schema for tables that already contain data, check your database system documentation for the appropriate tools. |
Published date: 05/24/2022
Last modified date: 02/24/2022