web

You’re offline. This is a read only version of the page.

News and Announcements icon

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

Microsoft Dynamics CRM (Archived)

How to delete a field in SQL without effecting NAV

(0) Share

Report

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 Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

JS-09031509-0 3

#2

AS-17030037-0 2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans