Samuele E. Locatelli
14 lines
450 B
Transact-SQL
14 lines
450 B
Transact-SQL
CREATE TABLE [dbo].[Vocabolario] (
|
|
[Lingua] NVARCHAR (3) NOT NULL,
|
|
[Lemma] NVARCHAR (50) NOT NULL,
|
|
[Traduzione] NVARCHAR (500) NOT NULL,
|
|
CONSTRAINT [PK_Vocabolario] PRIMARY KEY CLUSTERED ([Lingua] ASC, [Lemma] ASC),
|
|
CONSTRAINT [FK_Vocabolario_Lingue] FOREIGN KEY ([Lingua]) REFERENCES [dbo].[Lingue] ([Lingua]) ON UPDATE CASCADE
|
|
);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [I_lemma]
|
|
ON [dbo].[Vocabolario]([Lemma] ASC);
|
|
|