Create a database with script with express
Budget: $10 – $30 USD
Hi there I need to create a database with a script using express. For example create a table with the following structure but using express.
CREATE TABLE [dbo].[cotizaciones] (
[id] INT NOT NULL,
[ram] VARCHAR (50) NOT NULL,
[so] VARCHAR (50) NOT NULL,
[processadores] VARCHAR (50) NOT NULL,
[tiposervicio] VARCHAR (50) NOT NULL,
[observaciones] VARCHAR (50) NOT NULL,
[total] DECIMAL (18) NULL,
[dni] INT NULL,
PRIMARY KEY CLUSTERED ([id] ASC),
FOREIGN KEY ([dni]) REFERENCES [dbo].[personas] ([dni])
);
CREATE TABLE [dbo].[cotizaciones] (
[id] INT NOT NULL,
[ram] VARCHAR (50) NOT NULL,
[so] VARCHAR (50) NOT NULL,
[processadores] VARCHAR (50) NOT NULL,
[tiposervicio] VARCHAR (50) NOT NULL,
[observaciones] VARCHAR (50) NOT NULL,
[total] DECIMAL (18) NULL,
[dni] INT NULL,
PRIMARY KEY CLUSTERED ([id] ASC),
FOREIGN KEY ([dni]) REFERENCES [dbo].[personas] ([dni])
);