Function createtabledb
Writing functions
createtabledb(dbid, table, columns [, types, [, options])
Where dbid is the name of the variable returned by the opendb function, table is a variable
or string representing the name of the table, columns is a block (i.e., a block layout) or an array representing a list of column names of the future table
This function creates a table with the required parameters and properties.
If this database is external, you also need to specify: types - a block (i.e., design as a block) or an array representing a list of column types of the future table
Type Representation:
| Data type | String representation |
| Byte | byte |
| Short | short |
| Integer | int |
| Big Integer | bigint |
| Float | float |
| String | string |
| Long String | longstring |
| Time/Date | datetime |
Optional options parameter is a block (i.e. a block layout) or an array representing column parameters for an external database
separated by colons and representing column parameters:
| Specification | Description |
| null | The values in the column can take a NULL value |
| notnull | The values in the column cannot take a NULL value |
| primarykey | This column is the key |
| autoinc | Auto-magnification when adding a new record |
| default=value | This column will have the default value value if you need the value to contain a colon -
use the symbols "$#", for the dollar sign use the symbols "$$" |
Creating a table is an important step in database design, because it is in the tables that the basic information is stored, which allows you to organize effective data storage and management.
As an example, let's say that we need to create a "Users" table. To do this, we create a function that accepts the necessary parameters, such as the name of the table, a set of fields and their types, as well as additional restrictions.
The function starts by creating a new table in the database using the specified name. Then, we add columns to the table, specifying their names and corresponding data types, for example, a string type for storing user names and a numeric type for storing identifiers.
To improve the performance and structuring of the data, we can also add restrictions on fields. For example, we can set a restriction on the uniqueness of user IDs to avoid duplication of data. We can also specify restrictions on the required field filling using the keyword "NOT NULL" to ensure data integrity.
After specifying all the necessary fields and restrictions, the function finishes its work, saving the created table in the database. Thus, we create a reliable and structured table ready for storing user data.
It is important to note that the presented function creates only the structure of the table, and does not fill it with data. To create and add data to a table, you must use other functions and instructions.
Thus, the table creation function is an important tool in database design, allowing you to organize structured data storage and ensure their integrity and performance.
Help on built-in functions
The rules of programming scripts
Programm options
Color constants
