# Defining dynamic schema columns

The dynamic schema columns are easy to define. To define dynamic columns for the Databases Input and Output components, or for tFileInputDelimited and tFileOutputDelimited.

## Procedure

1. In the component's Basic settings tab, set the Property Type as Built-In.

   Information noteWarning: The dynamic schema is only supported in Built-In mode.
2. Click Edit schema to define the schema.

   The Schema dialog box opens.

   ![Schema dialog box.](https://help.qlik.com/talend/en-US/studio-user-guide/Resources/images/dynamic_schema_tFileInputDelimited_Edit_Schema.png)
3. In the last row added to the schema, enter a name for the dynamic column in the Column field.

   Information noteWarning: In the Database Input components, the SELECT query must include the \* wildcard, to retrieve all of the columns from the table selected.
4. Click the Type field and then the arrow which appears to select Dynamic from the list.