Update column information
put/sessions/{sessionId}/data/{libref}/{tableName}/columns/{columnName}
Updates the name, label, format, or informat information for a specified column.
1{2 "byteLength": 128,3 "charLength": 32,4 "id": "ID",5 "index": 1,6 "label": "Districts code",7 "length": 128,8 "links": [9 {10 "href": "/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/columns/ID",11 "method": "GET",12 "rel": "self",13 "type": "application/vnd.sas.compute.data.table.column",14 "uri": "/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/columns/ID"15 }16 ],17 "name": "ID",18 "type": "VARCHAR",19 "version": 220}
Name | Type | Required | Description |
---|---|---|---|
columnName | string | true | Specifies the column name to update. |
libref | string<object-id> | true | Specifies the libref for the request. |
sessionId | string<object-id> | true | Specifies the ID of the session. |
tableName | string<object-id> | true | Specifies the table that contains the column to update. |
Name | Type | Required | Description |
---|---|---|---|
If-Match | string | true | Specifies the ETag of the column that you are updating. |
Specifies the information to update for the column.
Describes a column from a table.
Example:
{"byteLength":128,"charLength":32,"id":"ID","index":1,"label":"Districts code","length":128,"links":[{"href":"/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/columns/ID","method":"GET","rel":"self","type":"application/vnd.sas.compute.data.table.column","uri":"/compute/sessions/RKEY-ses0000/data/MAPSGFK/AFGHANISTAN/columns/ID"}],"name":"ID","type":"VARCHAR","version":2}
Name | Type | Required | Description |
---|---|---|---|
format | Simple Column Formatting | false | Specifies the format to use for values in a column. Example: {"decimals":2,"length":10,"name":"DOLLAR10.2"} |
informat | Simple Column Formatting | false | Specifies the format to use for values in a column. Example: {"decimals":2,"length":10,"name":"DOLLAR10.2"} |
Status | Meaning | Description | ||
---|---|---|---|---|
200 | OK | The request succeeded. | Headers | Schema |
400 | Bad Request | The request was invalid. | Schema | |
404 | Not Found | No resource exists at the requested path. | Schema | |
412 | Precondition Failed | The `If-Match` request header did not match the resource's entity tag, or the `If-Unmodified-Since` request header did not match the resources last modified timestamp. | Schema | |
428 | Precondition Required | The request headers did not include an `If-Match` or `If-Unmodified-Since` precondition. | Schema |