Samuele Locatelli
9 lines
417 B
Transact-SQL
9 lines
417 B
Transact-SQL
CREATE TABLE [dbo].[RelazAL] (
|
|
[AL_parent] NVARCHAR (50) NOT NULL,
|
|
[AL_child] NVARCHAR (50) NOT NULL,
|
|
[dataMod] DATETIME CONSTRAINT [DF_RelazAL_dataMod] DEFAULT (getdate()) NULL,
|
|
CONSTRAINT [PK_RelazAL] PRIMARY KEY CLUSTERED ([AL_parent] ASC, [AL_child] ASC),
|
|
CONSTRAINT [FK_RelazAL_ElencoAssiemi] FOREIGN KEY ([AL_parent]) REFERENCES [dbo].[ElencoAssiemi] ([AL]) ON UPDATE CASCADE
|
|
);
|
|
|