Problema con FOREIGN KEy
Publicado por [email protected] (27 intervenciones) el 20/11/2007 15:18:28
Mi problema es el siguiente :
No funciona este codigo. Se supone que una tabla puede tener mas de una Foreign Key, pero no anda
------------------
--Foreign Key
------------------
CREATE TABLE [dbo].[T1] (
[CA] [int] NOT NULL CHECK([CA]>0),
[AR] [int] NOT NULL CHECK([AR]>0)
CONSTRAINT [T1_CA_PK] PRIMARY KEY ([CA],[AR])
CONSTRAINT [T1_CA_FK1] FOREIGN KEY ([CA],[AR]) REFERENCES [DBO].[T2] ([CA],[AR])
CONSTRAINT [T1_AR_FK2] FOREIGN KEY ([AR]) REFERENCES [DBO].[T3] ([AR])
) ON [PRIMARY]
--HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH--
CREATE TABLE [dbo].[T2] (
[PUI] [bigint] CHECK([PUI]>0),
[CA] [int] NOT NULL CHECK([CA]>0),
[AR] [int] NOT NULL CHECK([AR]>0),
[PUO] [bigint] CHECK([PUO]>0)
CONSTRAINT [T2_CA_PK] PRIMARY KEY ([CA],[AR])
CONSTRAINT [T2_CA_FK1] FOREIGN KEY ([CA],[AR]) REFERENCES [DBO].[T1] ([CA],[AR])
CONSTRAINT [T2_AR_FK2] FOREIGN KEY ([AR]) REFERENCES [DBO].[T3] ([AR])
) ON [PRIMARY]
--HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH--
CREATE TABLE [dbo].[T3] (
[AR] [int] NOT NULL UNIQUE CHECK([AR]>0)
CONSTRAINT [T3_AR_PK] PRIMARY KEY ([AR])
CONSTRAINT [T3_AR_FK1] FOREIGN KEY ([AR]) REFERENCES [DBO].[T1] ([AR])
CONSTRAINT [T3_AR_FK2] FOREIGN KEY ([AR]) REFERENCES [DBO].[T2] ([AR])
) ON [PRIMARY]
No funciona este codigo. Se supone que una tabla puede tener mas de una Foreign Key, pero no anda
------------------
--Foreign Key
------------------
CREATE TABLE [dbo].[T1] (
[CA] [int] NOT NULL CHECK([CA]>0),
[AR] [int] NOT NULL CHECK([AR]>0)
CONSTRAINT [T1_CA_PK] PRIMARY KEY ([CA],[AR])
CONSTRAINT [T1_CA_FK1] FOREIGN KEY ([CA],[AR]) REFERENCES [DBO].[T2] ([CA],[AR])
CONSTRAINT [T1_AR_FK2] FOREIGN KEY ([AR]) REFERENCES [DBO].[T3] ([AR])
) ON [PRIMARY]
--HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH--
CREATE TABLE [dbo].[T2] (
[PUI] [bigint] CHECK([PUI]>0),
[CA] [int] NOT NULL CHECK([CA]>0),
[AR] [int] NOT NULL CHECK([AR]>0),
[PUO] [bigint] CHECK([PUO]>0)
CONSTRAINT [T2_CA_PK] PRIMARY KEY ([CA],[AR])
CONSTRAINT [T2_CA_FK1] FOREIGN KEY ([CA],[AR]) REFERENCES [DBO].[T1] ([CA],[AR])
CONSTRAINT [T2_AR_FK2] FOREIGN KEY ([AR]) REFERENCES [DBO].[T3] ([AR])
) ON [PRIMARY]
--HHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH--
CREATE TABLE [dbo].[T3] (
[AR] [int] NOT NULL UNIQUE CHECK([AR]>0)
CONSTRAINT [T3_AR_PK] PRIMARY KEY ([AR])
CONSTRAINT [T3_AR_FK1] FOREIGN KEY ([AR]) REFERENCES [DBO].[T1] ([AR])
CONSTRAINT [T3_AR_FK2] FOREIGN KEY ([AR]) REFERENCES [DBO].[T2] ([AR])
) ON [PRIMARY]
Valora esta pregunta


0