Skip to main content
PATCH
/
api
/
database
/
tables
/
{tableName}
/
schema
Update Table Schema
curl --request PATCH \
  --url https://api.example.com/api/database/tables/{tableName}/schema \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --data '
{
  "addColumns": [
    {
      "columnName": "<string>",
      "isNullable": true,
      "isUnique": false,
      "defaultValue": "<string>"
    }
  ],
  "dropColumns": [
    "<string>"
  ],
  "updateColumns": [
    {
      "columnName": "<string>",
      "newColumnName": "<string>",
      "defaultValue": "<string>"
    }
  ],
  "addForeignKeys": [
    {
      "columnName": "<string>",
      "foreignKey": {
        "referenceTable": "<string>",
        "referenceColumn": "<string>",
        "onDelete": "RESTRICT",
        "onUpdate": "RESTRICT"
      }
    }
  ],
  "dropForeignKeys": [
    "<string>"
  ]
}
'
{ "message": "Table schema updated successfully", "tableName": "posts", "operations": [ "added 2 columns", "dropped 1 columns", "renamed 1 columns", "added 1 foreign keys", "dropped 1 foreign keys" ] }

Documentation Index

Fetch the complete documentation index at: https://docs.insforge.dev/llms.txt

Use this file to discover all available pages before exploring further.

Authorizations

​
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Path Parameters

​
tableName
string
required

Body

application/json
​
addColumns
object[]

Add new columns to the table

​
dropColumns
string[]

Remove columns from the table

Name of the column to drop

​
updateColumns
object[]

Modify existing columns (rename or change default)

​
addForeignKeys
object[]

Add foreign key constraints to existing columns

​
dropForeignKeys
string[]

Remove foreign key constraints from columns

Name of the column with foreign key to drop

​
renameTable
object

Rename the table

Response

Table schema updated successfully

​
message
string

Success message

​
tableName
string

Name of the updated table

​
operations
string[]

List of operations performed