Error in query when creating tables with foreign keys in SQL Server

0

I am executing a query with C # and I get the following error ..

This is the query that I'm executing, something fails, I do not know why, it still is not good sql ...

      CREATE TABLE Empresa( id_empresa int IDENTITY(1,1) NOT NULL PRIMARY KEY
                , nombre char(60) NOT NULL
                , giro char(50)
                , total_activos int NOT NULL
                , total_inactivos int NOT NULL
                )

      CREATE TABLE Usuario( id_usuario int NOT NULL PRIMARY KEY IDENTITY(1,1)
                , nombre char(60) NOT NULL
                , password char(200) NOT NULL
                , estatus int NOT NULL
                , ult_fecha_acceso DATETIME
                , CONSTRAINT FK_Usuario_Empresa FOREIGN KEY (id_empresa) REFERENCES Empresa (id_empresa) 
                )

       CREATE TABLE Historial( id_historial int NOT NULL PRIMARY KEY IDENTITY(1,1)
                  , inicio_sesion DATETIME NOT NULL
                  , cierre_sesion DATETIME
                  , CONSTRAINT FK_Historial_Usuario FOREIGN KEY (id_usuario) REFERENCES Usuario (id_usuario)
                  )

       CREATE TABLE DEF( id_def int NOT NULL PRIMARY KEY IDENTITY(1,1)
            , placa_original char(15) NOT NULL
            , estatus int NOT NULL
            , motivo char(500)
            , placa_editada char(15) NOT NULL
            , fecha_hora DATETIME NOT NULL
            , CONSTRAINT FK_DEF_Usuario FOREIGN KEY (id_usuario) REFERENCES Usuario (id_usuario)
            ) 
    
asked by Alberto Rojas 21.03.2017 в 17:31
source

1 answer

2

It throws you that error because you have not created the column that will serve as FK friend. I leave the code:

CREATE TABLE Usuario( id_usuario int NOT NULL PRIMARY KEY IDENTITY(1,1)
                , nombre char(60) NOT NULL
                , password char(200) NOT NULL
                , estatus int NOT NULL
                , ult_fecha_acceso DATETIME,
                empresa_id int FOREIGN KEY REFERENCES Empresa(id_empresa)
                )

You must apply the same for the other tables.

Greetings!

    
answered by 21.03.2017 / 17:39
source