Help Center/ Data Security Center/ API Reference/ API Description/ Static Data Masking/ Obtaining the Column List of a Database Table
Updated on 2026-01-13 GMT+08:00
Online Debugging
CLI Examples
View PDF
Share

Obtaining the Column List of a Database Table

Function

This API is used to obtain the column list of a specified table based on database information.

Calling Method

For details, see Calling APIs.

URI

POST /v1/{project_id}/sdg/server/mask/dbs/rdbs/tables/columns

Table 1 Path Parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Unique project ID.
Table 2 Query Parameters

Parameter

Mandatory

Type

Description

type

Yes

String

Database type

Request Parameters

Table 3 Request body parameters

Parameter

Mandatory

Type

Description

db_id

No

String

Unique ID of a database.

db_name

No

String

Database name

schema

No

String

Database mode

sequence

No

String

Sorting field of the database table.

table_name

No

String

Database table name.

Response Parameters

Status code: 200

Query result

Status code: 201

Resource creation.

None

Example Requests

POST /v1/{project_id}/sdg/server/mask/dbs/rdbs/tables/columns

{
  "db_id" : "string",
  "db_name" : "string",
  "schema" : "string",
  "sequence" : "string",
  "table_name" : "string"
}

Example Responses

None

Status Codes

Status Code

Description

200

Query result

201

Resource creation.

401

Unauthorized.

403

Access denied.

404

Resource not found.

Error Codes

See Error Codes.

Parent topic: Static Data Masking