|
|
|
|
|
|
|
|
|
|
version 11
Using the SQL Data Definition Language (DDL), you can define and manage the database structure.
With DDL commands, you can create or alter tables and fields, as well as add and/or remove data.
Here is a simple example that creates a table, adds a few fields, then fills those fields with some data.
To test the above example, in the main window of the "4D SQL Code Samples" database, press the DDL button.
Note: This example will only work once because if you press the "DDL" button a second time, you will get an error message telling you that the table already exists.
|
|
|
|
|
|
|
|
|
|