How to delete a field in SQL without effecting NAV

(0) Share

Report

Posted on by Community Member

We created two fields in 37 Sales Line Table.
And then we deleted them because we are not using those two fields. But these two fields are updated in SQL Server. That's why we faced "Null value in SQL not allowed for those two fields".
Thus we added those two fields in 37 table again,,Now it is showing
"The following SQL error was unexpected. Column names in each table must be unique. Column name in table is specified more than once."

Table is not compiling and ales Orders stopped. Can anyone suggest what to do...

*This post is locked for comments

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Member on at

Like (1)

Report

RE: How to delete a field in SQL without effecting NAV

Issue Solved!!

We deleted the columns in SQL by executing a code

USE <DATABASE NAME>

GO

ALTER [<TABLE NAME>]

DROP COLUMN [NAME];

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: How to delete a field in SQL without effecting NAV

Where do you executing this code in? I would like to delete a field as well.

Was this reply helpful? Yes No