Bug Create DDL Script for Table with MS SQL server

[BachLuu]

Type: Bug

Error getting answers, error: MS SQL does not have table in getObject. The following errors occurred: answers: Could not retrieve DDL for answers.
Step 1: Click to Create (DDL)
Step2: Error

Extension version: 1.19.10
VS Code version: Code 1.106.3 (bf9252a2fb45be6893dd8870c0bf37e2e1766d61, 2025-11-25T22:28:18.024Z)
OS version: Windows_NT x64 10.0.26200
Modes:

System Info

Item	Value
CPUs	AMD Ryzen 5 5600H with Radeon Graphics (12 x 3294)
GPU Status	2d_canvas: enabled direct_rendering_display_compositor: disabled_off_ok gpu_compositing: enabled multiple_raster_threads: enabled_on opengl: enabled_on rasterization: enabled raw_draw: disabled_off_ok skia_graphite: disabled_off trees_in_viz: disabled_off video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	undefined
Memory (System)	15.86GB (3.96GB free)
Process Argv	--folder-uri file:///d%3A/CODE-BASE/BackEnd%20Project/Spring%20Project/SpringBootWeb/SpringBootWeb --crash-reporter-id a1d7719d-935a-4c55-967a-1310a0f06e31
Screen Reader	no
VM	0%

A/B Experiments

vsliv368cf:30146710
binariesv615:30325510
nativeloc1:31344060
dwcopilot:31170013
dwoutputs:31242946
copilot_t_ci:31333650
e5gg6876:31282496
pythonrdcb7:31342333
6518g693:31334701
aj953862:31281341
4f60g487:31327383
nes-set-on:31351930
63221493:31336333
envsdeactivate2:31353495
editstats-enabled:31346257
cloudbuttont:31379625
todos-1:31405332
qwen_all_req:31402696
3efgi100_wstrepl:31403338
trigger-command-fix:31379601
auto_model_enabled:31385282
use-responses-api:31390855
je187915:31401257
afag3459:31428711
ec5jj548:31422691
copilot-nes-oct-t:31418199
terminalsuggestenabled:31426255
cmp-ext-treat:31426748
cp_cls_c_966_ss:31426491
defaultvisibility:31426295
expandedtokens:31427242
c0683394:31419495
g0h3h215:31426582
478ah919:31426797
2bd77578_control:31426889
nes-autoexp-20:31426650
a5gib710:31426879
5j92g670_sonnet:31426787
cp_jb_t_lixleitest:31428973
406hc587_ask_agent:31428393

[mikeburgh]

Thanks for raising this… the issue with SQL Server is that they don't have a native way to generate the actual table DDL…

I have looked at solutions but there are not that can I find to generate/get the real table DDL.. so at the moment the two choices I am considering.. hide that option (feels wrong).. or generate one from the schema information… which may not include all the details from the true table (fill factor on indexes etc) and add a comment that it's been auto generated and should be checked against the original etc..

Again neither are great options.. but keen for feedback..

[mikeburgh]

I have just released 1.32.1 which will now generate the DDL.. it adds a bit of a disclaimer at the top, just detailing out what it does and does not include.. as this is hand built, there is no server side way to generate the DDL for a table in SQL Server.