Type formatting/text/sdatabase/05030300.xhpSun Microsystems, Inc.
Type formatting
In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The Type formatting dialog is the third window of the Copy table dialog.
List box
Lists the data fields that will be included in to the copied table.
Column information
Field name
Displays the name of the selected data field. If you want, you can enter a new name.
Field type
Select a field type.
Length
Enter the number of characters for the data field.
Decimal places
Enter the number of decimal places for the data field. This option is only available for numerical or decimal data fields.
Default value
Select the default value for a Yes/No field.
Automatic type recognition
$[officename] can automatically recognize field contents when you copy database tables by drag and drop.
(max.) lines
Enter the number of lines to use for automatic type recognition.