create_table
Generate a new table in MSSQL databases by defining table name and column specifications. Supports precise SQL data types and constraints for structured data storage.
Instructions
Creates a new table in the MSSQL Database with the specified columns.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columns | Yes | Array of column definitions (e.g., [{ name: 'id', type: 'INT PRIMARY KEY' }, ...]) | |
| tableName | Yes | Name of the table to create |
Input Schema (JSON Schema)
{
"properties": {
"columns": {
"description": "Array of column definitions (e.g., [{ name: 'id', type: 'INT PRIMARY KEY' }, ...])",
"items": {
"properties": {
"name": {
"description": "Column name",
"type": "string"
},
"type": {
"description": "SQL type and constraints (e.g., 'INT PRIMARY KEY', 'NVARCHAR(255) NOT NULL')",
"type": "string"
}
},
"required": [
"name",
"type"
],
"type": "object"
},
"type": "array"
},
"tableName": {
"description": "Name of the table to create",
"type": "string"
}
},
"required": [
"tableName",
"columns"
],
"type": "object"
}