<\/i>Edit Data is in Public Preview.<\/strong><\/p>We are actively adding more features, improving usability, and expanding capabilities. Your feedback is extremely important \u2014 please tell us what works, what doesn\u2019t, and what you\u2019d like us to improve.<\/div><\/p>\n To use Edit Data (Preview), you must enable the experimental features\u00a0setting in the MSSQL extension.<\/p>\n Open Settings<\/strong> in VS Code<\/p>\n<\/li>\n Search for \u201cMSSQL: Enable Experimental Features\u201d<\/strong><\/p>\n<\/li>\n Check the box to enable it<\/p>\n<\/li>\n Reload VS Code if prompted<\/p>\n<\/li>\n<\/ol>\n <\/i>Edit Data is only available in MSSQL extension v1.37 or later.<\/strong><\/p>If you do not see the option, update your extension first.<\/div><\/p>\n To launch the Edit Data experience:<\/p>\n Right-click any table<\/strong> in the Object Explorer and select \u201cEdit Data (Preview)\u201d<\/strong><\/p>\n<\/li>\n Or simply double-click the table name<\/strong><\/p>\n<\/li>\n<\/ol>\n This opens a new editor tab containing the data grid for that table.<\/p>\n Once you edit a cell, your changes are validated immediately \u2014 even before saving. Edit Data (Preview) checks for invalid data types, unique or primary key violations, NULL values in non-nullable columns, and more. If an issue is detected, an error dialog appears to help you understand and resolve the problem.<\/p>\n Select Show Script<\/strong> in the toolbar to open a read-only pane displaying the DML generated by your edits \u2014 including INSERT, UPDATE, and DELETE statements.<\/p>\n The script updates automatically as you modify or revert data.<\/p>\n When ready, choose Save Changes<\/strong> to commit your updates.\n Edit Data is designed for smooth navigation across large datasets \u2014<\/strong>\u00a0modify Total rows to fetch, <\/strong>adjust Rows per page, <\/strong>navigate between pages \u2014 <\/strong>allowing you to locate records quickly.<\/p>\n Edit Data is still in Public Preview \u2014 and we are actively adding more capabilities, refining interactions, and enhancing performance. Your feedback right now is critical and directly shapes what we build next. Please share your thoughts \u2014 every piece of feedback helps!<\/p>\n","protected":false},"excerpt":{"rendered":" Overview Working with table data is an essential part of database development \u2014 whether you\u2019re validating behavior, debugging issues, or quickly seeding data. But switching between tools or writing repetitive T-SQL statements can slow down your workflow. We are excited to announce the Public Preview of Edit Data in the MSSQL extension for Visual Studio […]<\/p>\n","protected":false},"author":187531,"featured_media":6247,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,533,625],"tags":[682],"class_list":["post-6227","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure-sql","category-visual-studio-code","category-vs-code","tag-vscode-mssql"],"acf":[],"blog_post_summary":" Overview Working with table data is an essential part of database development \u2014 whether you\u2019re validating behavior, debugging issues, or quickly seeding data. But switching between tools or writing repetitive T-SQL statements can slow down your workflow. We are excited to announce the Public Preview of Edit Data in the MSSQL extension for Visual Studio […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/6227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/users\/187531"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/comments?post=6227"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/posts\/6227\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media\/6247"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/media?parent=6227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/categories?post=6227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-json\/wp\/v2\/tags?post=6227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to get started: Enable Experimental Features (Required)<\/h1>\n
\n
![\"enable](\"https:\/\/devblogs.microsoft.com\/azure-sql\/wp-content\/uploads\/sites\/56\/2025\/11\/enable-experimental-features.webp\")
<\/a><\/p>\nOpen Edit Data<\/h1>\n
\n
<\/a><\/p>\nBrowse and Edit Table Data<\/h1>\n
\n
<\/a><\/p>\nView Changes in Show Script Pane<\/h1>\n
<\/a><\/p>\nSave or Discard Changes<\/h1>\n
<\/a><\/p>\nPagination and Row Fetching<\/h1>\n
<\/a><\/p>\nNext Steps<\/h1>\n
\n