IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Trn_Face' AND COLUMN_NAME = 'FechaValidacion') ALTER TABLE Trn_Face add FechaValidacion datetime GO ALTER TABLE Trn_TraEspPasajeros ADD FechaNac SMALLDATETIME, IncluirPeriodo BIT DEFAULT 0 NOT NULL