﻿--Migration
IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'dbo' AND TABLE_NAME = 'T_ORARENDTELJES' AND COLUMN_NAME = 'C_MAXORASZAM')
    ALTER TABLE T_ORARENDTELJES
        ADD C_MAXORASZAM TINYINT NULL
GO

exec dev.uspCreateSchemaViews 'T_ORARENDTELJES'
GO