if exists (select 1਀   昀爀漀洀 猀礀猀⸀猀礀猀爀攀昀攀爀攀渀挀攀猀 爀 樀漀椀渀 猀礀猀⸀猀礀猀漀戀樀攀挀琀猀 漀 漀渀 ⠀漀⸀椀搀 㴀 爀⸀挀漀渀猀琀椀搀 愀渀搀 漀⸀琀礀瀀攀 㴀 ✀䘀✀⤀
   where r.fkeyid = object_id('ftPedidoRelacionamento') and o.name = 'FK_ftPedidoRelacionamento_ftPedido')਀愀氀琀攀爀 琀愀戀氀攀 昀琀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀洀攀渀琀漀
   drop constraint FK_ftPedidoRelacionamento_ftPedido਀最漀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ㄀
   from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')਀   眀栀攀爀攀 爀⸀昀欀攀礀椀搀 㴀 漀戀樀攀挀琀开椀搀⠀✀昀琀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀洀攀渀琀漀✀⤀ 愀渀搀 漀⸀渀愀洀攀 㴀 ✀䘀䬀开昀琀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀洀攀渀琀漀开昀琀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀搀漀✀⤀
alter table ftPedidoRelacionamento਀   搀爀漀瀀 挀漀渀猀琀爀愀椀渀琀 䘀䬀开昀琀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀洀攀渀琀漀开昀琀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀搀漀
go਀
if exists (select 1਀            昀爀漀洀  猀礀猀漀戀樀攀挀琀猀
           where  id = object_id('ftPedidoRelacionamento')਀            愀渀搀   琀礀瀀攀 㴀 ✀唀✀⤀
   drop table ftPedidoRelacionamento਀最漀
਀⼀⨀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀⨀⼀
/* Table: ftPedidoRelacionamento                                */਀⼀⨀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀㴀⨀⼀
create table ftPedidoRelacionamento (਀   䤀搀倀攀搀椀搀漀             䤀搀匀攀焀甀攀渀挀椀愀          渀漀琀 渀甀氀氀Ⰰ
   IdPedidoRelacionado  IdSequencia          not null,਀   挀漀渀猀琀爀愀椀渀琀 倀䬀开䘀吀倀䔀䐀䤀䐀伀刀䔀䰀䄀䌀䤀伀一䄀䴀䔀一吀伀 瀀爀椀洀愀爀礀 欀攀礀 ⠀䤀搀倀攀搀椀搀漀Ⰰ 䤀搀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀搀漀⤀
)਀最漀
਀愀氀琀攀爀 琀愀戀氀攀 昀琀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀洀攀渀琀漀
   add constraint FK_ftPedidoRelacionamento_ftPedido foreign key (IdPedido)਀      爀攀昀攀爀攀渀挀攀猀 昀琀倀攀搀椀搀漀 ⠀䤀搀倀攀搀椀搀漀⤀
go਀
alter table ftPedidoRelacionamento਀   愀搀搀 挀漀渀猀琀爀愀椀渀琀 䘀䬀开昀琀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀洀攀渀琀漀开昀琀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀搀漀 昀漀爀攀椀最渀 欀攀礀 ⠀䤀搀倀攀搀椀搀漀刀攀氀愀挀椀漀渀愀搀漀⤀
      references ftPedido (IdPedido)਀最漀
਀椀昀 攀砀椀猀琀猀 ⠀猀攀氀攀挀琀 ㄀
   from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')਀   眀栀攀爀攀 爀⸀昀欀攀礀椀搀 㴀 漀戀樀攀挀琀开椀搀⠀✀昀眀唀猀甀愀爀椀漀✀⤀ 愀渀搀 漀⸀渀愀洀攀 㴀 ✀䘀䬀开昀眀唀猀甀愀爀椀漀开昀眀䔀洀瀀爀攀猀愀✀⤀
alter table fwUsuario਀   搀爀漀瀀 挀漀渀猀琀爀愀椀渀琀 䘀䬀开昀眀唀猀甀愀爀椀漀开昀眀䔀洀瀀爀攀猀愀
go਀
alter table fwUsuario਀  愀搀搀 䤀搀䔀洀瀀爀攀猀愀 猀洀愀氀氀椀渀琀 渀甀氀氀
go਀
update fwUsuario਀猀攀琀 䤀搀䔀洀瀀爀攀猀愀 㴀 ⠀猀攀氀攀挀琀 洀椀渀⠀䤀搀䔀洀瀀爀攀猀愀⤀ 昀爀漀洀 昀眀䔀洀瀀爀攀猀愀⤀
go਀
alter table fwUsuario਀  愀氀琀攀爀 挀漀氀甀洀渀 䤀搀䔀洀瀀爀攀猀愀 猀洀愀氀氀椀渀琀 渀漀琀 渀甀氀氀
go਀
alter table fwUsuario਀   愀搀搀 挀漀渀猀琀爀愀椀渀琀 䘀䬀开昀眀唀猀甀愀爀椀漀开昀眀䔀洀瀀爀攀猀愀 昀漀爀攀椀最渀 欀攀礀 ⠀䤀搀䔀洀瀀爀攀猀愀⤀
      references fwEmpresa (IdEmpresa)਀最漀
਀椀渀猀攀爀琀 椀渀琀漀 昀眀嘀攀爀猀愀漀 瘀愀氀甀攀猀⠀㄀Ⰰ㐀Ⰰ㈀⤀
go਀