Database data type creation and reuse

摘要

Embodiments are provided for creating and reusing custom data types in a database. A selection of a field or group of fields may be received from a database table in the database by a database software application executing on a computer system. Each selected field may include a set of field properties. The application may further receive a user input to initiate saving the selected field or group of fields as a custom data type. In response to receiving the input, the application may be configured to generate a dialog for receiving custom data type information for the selected field or group of fields and save the selected field or group of fields as a custom data type. The custom data type may then be reused by the application in the database.

主权项

1. A computer-implemented method for creating and reusing custom data types in a database, comprising:
providing a user interface gallery displaying a plurality of rows of default data types, the displayed plurality of rows of the default data types comprising a plurality of disparate data types and a plurality of data type categories, the user interface gallery further displaying at least one of the plurality of data type categories as one of the default data types in another one of the plurality of data type categories, the default data types being associated with a displayed database, the default data types being utilized in creating the custom data types; receiving, by the computer, a selection of a first field and a second field from a database table in the database, the first field and the second field comprising a set of field properties; receiving, in the user interface gallery, an input to initiate saving the field properties associated with the selected first field and second field for creating a custom data type; generating a dialog for receiving custom data type information, the custom data type information including any one of: a name, an icon, a category, a preview image or a description; saving the field properties and the custom data type information as the custom data type; displaying the custom data type in the user interface gallery; receiving a selection of the custom data type from the user interface gallery, the custom data type comprising a plurality of the default data types displayed in the user interface gallery; and reusing the custom data type in the database.