Alter table

IF NOT EXISTS(SELECT * from INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='tblpatient' and COLUMN_NAME='Externalid')BEGIN
ALTER TABLE tblpatient ADD vinoth NVARCHAR(9) NULLEND