Skip to content

TableTypes

Andreas edited this page Jan 23, 2023 · 1 revision

The Table types section offers a list of all custom table types of the selected database with some additional information.

image

On the left you will find all of your table types with a small search function (text box under the list). If you select a table type the columns of the type will be shown of the right side.

Here a short explanation of the columns:

Column Description
Pos. The position / order of the column in the table
Name The name of the column (obviously)
Type The data type of the column
Max. Length The max. length of the column. This value is a little bit tricky, because it shows the length for "text" columns but the needed space (in bit) for other data types like int.
Precision The precision of the column (for example how many decimal places)
PK Indicates if the columns is a part of the primary key
Identity Indicates if the column is an identity column (auto increment for MySql users 😎)
Null Indicates the column allows null values
Computed Indicates if the content of the column is computed
Default The default value of the column

Clone this wiki locally