Diseñu de tabla

In the Table Design window you define new tables or edit the structure of an existing table.

P'aportar a esti comandu...

In a database file window, click the Tables icon. Choose Insert - Table Design or Edit - Edit.


Información xeneral de bases de datos

Diseñu de tabla

La ventana dispon de la so propia barra de menúes. Tamién contién el comandu nuevu siguiente: Diseñu d'índiz

Área de definición de tabla

Esta área ye onde se define la estructura de la tabla.

Nome del campu

Specifies the name of the data field. The database engine may impose restrictions on the length of the table name, and the use of special characters and spaces within the table name.

Triba de campu

Specifies the field type. The available field types are limited by the database engine being used.

Descripción

Specifies an optional description for each field.

Les testeres de les fileres contienen les ordes de menú contestuales siguientes:

Cortar

Corta la filera escoyida nel cartafueyu.

Copiar

Copia la filera escoyida nel cartafueyu.

Pegar

Pega'l conteníu del cartafueyu.

Desaniciar

Desanicia la filera escoyida.

Inxertar fileres

Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has already been saved.

Llave primaria

If this command has a check mark, the data field is defined as a primary key. By clicking the command you activate/deactivate the primary key definition of the field. The command is only visible if the data source supports primary keys.

Propiedaes del campu

Define les propiedaes de campu del campu escoyíu.

Llargor

Specifies the maximum number of characters allowed for data entry of the corresponding data field including any spaces or special characters.

Decimales

Indique'l númberu de decimales pa un campu numbérico o decimal.

Valor predetermináu

Especifica'l valor predetermináu nos nuevos rexistros de datos.

Exemplu de formatu

Displays the format code to assign to the field value that you can select with the ... button.

...

Esti botón abre'l diálogu Formatu de campu.

Área d'ayuda

Displays a help string or hint defined by the database designer for the given field.

Please support us!