Around 10 properties are exposed which mean respective DB table columns created in Dev DB. Now when I deploy this product in to QA should I write Alter table scripts for this 10 properties to effect of expose? I think there should be other way around like save class instances or DB-Table-Admin ... please advice
I think you can run db scripts(to expose columns, create table etc.) automatically during pega code deployment only if your system's Production Level is <= 2. There is some DSS which can be set true or false which will decide whether you can even expose in systems with production level<=2.
I think this is a good strategy by design as most of the organization's DBA team would not want any DDLs to be executed automatically for audit reasons in higher environments. So from my experience it is always advisable to create separate scripts for DB changes and get them executed through DBA team.