clave foranea

[treces]

como modificar la Clave Foranea de una tabla???
tengo dos tablas que estan ligadas una saca de la clave primaria de la otra un dato! este dato lo quiero modificar, noc si deba crear una tabla o cambiarle atributos de las tablas para lograr esto. Ayuda plzzz

[Libras]

si estan ligadas las tablas deberias de modificar la tabla de donde se saca el id, ahora como tienes tus relaciones foraneas? activaste el update or delete en cascada??

saludos!

[treces]

USE [cms]
GO

/****** Object: Table [dbo].[SbiSiteBehavior] Script Date: 06/15/2012 10:37:56 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SbiSiteBehavior](
[SbiID] [int] NOT NULL,
[Server] [smallint] NOT NULL,
[Site] [smallint] NOT NULL,
[Behavior] [smallint] NOT NULL,
[Imported] [bit] NOT NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [SbiSiteBehavior_PK] PRIMARY KEY CLUSTERED
(
[SbiID] ASC,
[Site] ASC,
[Behavior] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'Version', @value=N'$Revision: 6 $' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SbiSiteBehavior '
GO

ALTER TABLE [dbo].[SbiSiteBehavior] WITH NOCHECK ADD CONSTRAINT [FK_SbiSiteBehavior_Sbi] FOREIGN KEY([SbiID])
REFERENCES [dbo].[Sbi] ([SbiId])
NOT FOR REPLICATION
GO

ALTER TABLE [dbo].[SbiSiteBehavior] CHECK CONSTRAINT [FK_SbiSiteBehavior_Sbi]
GO

ALTER TABLE [dbo].[SbiSiteBehavior] WITH NOCHECK ADD CONSTRAINT [SbiSiteBehavior_F01] FOREIGN KEY([Behavior], [Server])
REFERENCES [dbo].[AC_BEHAVIOR] ([BEHAVIOR_ID], [SERVER_ID])
NOT FOR REPLICATION
GO

ALTER TABLE [dbo].[SbiSiteBehavior] CHECK CONSTRAINT [SbiSiteBehavior_F01]
GO

ALTER TABLE [dbo].[SbiSiteBehavior] ADD DEFAULT ((1)) FOR [Server]
GO

ALTER TABLE [dbo].[SbiSiteBehavior] ADD DEFAULT ((0)) FOR [Imported]
GO

ALTER TABLE [dbo].[SbiSiteBehavior] ADD DEFAULT (newid()) FOR [rowguid]
GO







USE [cms]
GO

/****** Object: Table [dbo].[AC_BEHAVIOR] Script Date: 06/15/2012 10:37:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AC_BEHAVIOR](
[BEHAVIOR_ID] [smallint] NOT NULL,
[DESCRIPTION] [nvarchar](35) NULL,
[SITE] [smallint] NULL,
[SERVER_ID] [smallint] NOT NULL,
[LocationTagName] [dbo].[LocationTagNameType] NOT NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,
CONSTRAINT [PK_AC_BEHAVIOR] PRIMARY KEY CLUSTERED
(
[BEHAVIOR_ID] ASC,
[SERVER_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'Version', @value=N'$Revision: 7 $' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AC_BEHAVIOR'
GO

ALTER TABLE [dbo].[AC_BEHAVIOR] WITH NOCHECK ADD CONSTRAINT [AC_BEHAVIOR_F01] FOREIGN KEY([SITE])
REFERENCES [dbo].[AC_SITE] ([SITE])
NOT FOR REPLICATION
GO

ALTER TABLE [dbo].[AC_BEHAVIOR] CHECK CONSTRAINT [AC_BEHAVIOR_F01]
GO

ALTER TABLE [dbo].[AC_BEHAVIOR] ADD DEFAULT ((1)) FOR [SERVER_ID]
GO

ALTER TABLE [dbo].[AC_BEHAVIOR] ADD DEFAULT (newid()) FOR [rowguid]
GO



quiero es modificar mi taba sbisitebehavior el campo behavior