Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) How to delete a field ...

How to delete a field in SQL without effecting NAV

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

All responses (2)

Answers (1)

Community Member Microsoft Employee 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.
Verified answer

Community Member Microsoft Employee 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];