Error trying to insert SQL SERVER

Question

I created a table in the BD with the following code

CREATE TABLE documentosDefesa
(
id_documentos_defesa int NOT NULL,
id_reclamatoria int NOT NULL,
funcao nvarchar(50) NULL
);

And now when I try to make the following insertion,:

INSERT INTO [RDO].[dbo].[documentosDefesa] (id_reclamatoria, funcao) VALUES (177,'Pedreiro')

in SQL SERVER MANAGEMENT it displays the following warning:

Cannot insert NULL value in column 'id_documents_defense', table 'RDO.dbo.documentsDefesa'; column does not allow nulls. INSERT failure.

I don’t understand why I made a mistake, because it’s not the first time I’ve created a table and I do it!

Answer 1

The way you created your table, it is set that the id_documents_defense field cannot be null, and at the time of inserting, you are not specifying value for such field (which cannot be null).

Perhaps you expected this field to be auto-incremented. For that, you would have to create your table as follows:

CREATE TABLE documentosDefesa
(
    id_documentos_defesa int IDENTITY(1,1) PRIMARY KEY,
    id_reclamatoria int NOT NULL,
    funcao nvarchar(50) NULL
);

Or change the SQL statement. for example:

INSERT INTO [RDO].[dbo].[documentosDefesa] (id_documentos_defesa, id_reclamatoria, funcao) VALUES (1, 177,'Pedreiro')

If you don’t want to delete the whole table, you can only change the ID column:

ALTER TABLE documentosDefesa DROP COLUMN id_documentos_defesa;
ALTER TABLE documentosDefesa ADD id_documentos_defesa int IDENTITY(1,1);