Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
N
N
Nik Faraday2021-11-08 14:50:40
Microsoft SQL Server Management Studio
Nik Faraday, 2021-11-08 14:50:40

How to make a field NULL-accessible?

You need to change the schema of the data. In SSMS, configure the field so that it can take the NULL value.

Mistake
61890f0447066222839867.png

How to fix it?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)
Report
K
Konstantin Tsvetkov, 2021-11-08
@NikFaraday

Options
618926c4db960463726853.png

Explanation .

Report
V
Vasily Bannikov, 2021-11-08
@vabka

Drop the table and recreate it, which is what ssms tells you

Similar questions
M
Michael Vasyukov2017-11-23 20:29:34
How to join an int primary key to a smallint foreign key? 1Reply
M
Michael Vasyukov2017-11-27 07:54:20
Unable to compose correct UPDATE ms sql query? 1Reply
M
Michael Vasyukov2017-12-02 17:36:10
How to make a sql query to select data from several tables by FK? 1Reply
A
Alex Lezz2018-01-04 10:00:54
How to implement Microsoft SQL Server commands in C# windows forms? 2Reply
A
Al Tinho2018-01-26 09:28:35
What does this SQL script do? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question