# PROVIDERATTRIBUTES
- Primary Keys: `rowid
Can retrieve data and change data using insert, update and delete.
## Table Columns
The columns of the table `PROVIDERATTRIBUTES` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `ALLOW_SET_FROM_CONNECTION_STRING` | `char` | Allow Set from Connecton String | | Whether to allow setting the value from connection string. |
| `ALLOW_SET_FROM_LOG_ON` | `char` | Allow Set from Log On | | Whether to allow setting the value from log on window. |
| `ALLOW_SET_FROM_PROVIDER_FILE` | `char` | Allow Set from Provider File | | Whether to allow setting the value from provider file. |
| `ALLOW_SET_FROM_SET_STATEMENT` | `char` | Allow Set from Set Statement | | Whether to allow setting the value from set SQL statement. |
| `CATEGORY` | `varchar2(4000)` | Category | ☐ | Category of the attribute. |
| `CODE` | `varchar2(240)` | Code | ☑ | Code of the attribute. |
| `DEFAULT_VALUE` | `varchar2` | | ☐ | |
| `DEFINING_TYPE_PROVIDER_DISPLAY_NAME` | `varchar2(240)` | Defining Type Provider Display Name | ☐ | Display name of the provider for the defining type. |
| `DESCRIPTION` | `varchar2(4000)` | Description | ☑ | Description of the attribute. |
| `DISPLAY_ORDER` | `int32` | Display Order | ☑ | Display order. |
| `EXPLANATION` | `varchar2(4000)` | Explanation | ☐ | Explanation of the attribute. |
| `RUN_ID` | `guid` | | ☑ | |
| `rowid
| `number` | Row ID | ☑ | Artificial primary key of an in-memory table. |