CASE WHEN DATA_TYPE = 'varchar' OR DATA_TYPE = 'nvarchar' THEN '(' + ltrim(str(CHARACTER_MAXImUM_LENGTH)) + ')' WHEN DATA_TYPE = 'decimal' OR DATA_TYPE = 'numeric ...
CreditCardProcessingMerchantServiceCompanyCode TINYINT CHECK(CreditCardProcessingMerchantServiceCompanyCode between 1 and 20) NOT NULL, CreditCardNetworkCompanyCode ...