Broken Database Table

Unknown

Broken Database Table

Unknown

I was trying to save XML as a string in a database, and apparently it doesn’t like that. Now my table is corrupted, and I can’t figure out how to just delete all the data from it and start over rebuilding it. Any thoughts? Here’s a snapshot of the data after I tried to fix it, but I can’t get rid of that last entry where it thinks a string field is a text box.

[img]att2[/img]

The following is stored in it:

[img]att1[/img]

I try to delete it but can’t. Also, there is no id for that row, so not sure how to address it.

Thoughts?

Unknown

Hi, Decisions is equipped with its own [url=https://documentation.decisions.com/docs/query-editor]Query Editor[/url]. You can connect to your DB and run a delete from TableX query to clear all of that data.

Additionally, XML text should be [url=https://www.red-gate.com/simple-talk/sql/learn-sql-server/sql-server-xml-questions-you-were-too-shy-to-ask/]stored in an XML column instead of a string in your DB[/url] so that your DB knows how to handle the data correctly.