Hi Welington,

If you want to trigger an update to a field in a master table and update the child tables related records try this example. I haven't had time to test it but it should work.

CREATE TRIGGER [UPDATE] ON [dbo].[master_table] FOR UPDATE
AS

--Is the key field updated
IF UPDATE(id)
BEGIN
	declare @old_id as int
	declare @new_id as int

	--Before update
	set @old_id = (select id from deleted)

	--After update
	set @new_id = (select id from inserted)

	--Update child table
	update child_table set id = @new_id where id = @old_id
END

GO