# PROVIDERTABLEFUNCTIONPARAMETERS - Primary Keys: `rowid Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `PROVIDERTABLEFUNCTIONPARAMETERS` 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 | |---|:---:|---|:---:|---| | `DATABASE_DATA_TYPE` | `varchar2` | Database Data Type | | Data type in the database. | | `DATA_FORMAT` | `varchar2(60)` | Data Format | ☐ | Data format. | | `DEFAULT_VALUE` | `varchar2` | Default Value | ☐ | Default value. | | `DOCUMENTATION` | `varchar2` | Documentation | | Documentation. | | `DOTNET_DATA_TYPE` | `varchar2` | .NET Data Type | | Data type for .NET. | | `NAME` | `varchar2` | Name | | Name of the column. | | `PRESENCE_REQUIRED` | `char` | Presence Required | | Whether the presence of a value is required. | | `RUN_ID` | `guid` | | ☑ | | | `SORTING_ORDER` | `int32` | Sort Order | | Sorting order of the parameter within the table function. | | `TABLE_CATALOG_NAME` | `varchar2` | Table Catalog | | Catalog where the tables are contained in. | | `TABLE_FULL_QUALIFIED_NAME` | `varchar2(240)` | Table Full Qualified Name | | Full qualified name. | | `TABLE_NAME` | `varchar2` | Table Name | | Name of the table or view. | | `TABLE_SCHEMA_NAME` | `varchar2` | Table Schema | | Schema within the catalog where the table is contained in. | | `rowid | `number` | Row ID | ☑ | Artificial primary key of an in-memory table. |