In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The Type formatting dialogue box is the third window of the Copy table dialogue box.
Lists the data fields that will be included in to the copied table.
Displays the name of the selected data field. If you want, you can enter a new name.
Select a field type.
Enter the number of characters for the data field.
Enter the number of decimal places for the data field. This option is only available for numerical or decimal data fields.
Select the default value for a Yes/No field.
LibreOffice can automatically recognise field contents when you copy database tables by drag and drop.
Enter the number of lines to use for automatic type recognition.
Enables automatic type recognition.