I just tried to create a view in the DDT based on a Union query. The view looks something like this:



Select Distinct

us_pk

,pm_id

,pm_key

,up_action

From SFSUserPermissionInfo



Union



Select Distinct

us_pk

,pm_id

,pm_key

,up_action

From SFSUserRolePermissionInfo



When I save it, it reports the following as the columns:



Column Table

----------------- --------------------------------------

pm_pk SFSPermissions

pm_pk SFSPermissions

pm_key SFSPermissions

pm_Key SFSPermissions

up_Action SFSUsersXPermissions

rp_Action SFSUsersXRoles

Distinct| us_pk SFSUserPermissionInfo| || Union

Distinct| us_pk SFSUserPermissionInfo| || Union



I deployed it and built a BO off of it and all seems to work, but the columns/tables are weird. I'm assuming that there are no significant ramifications of this, but I'd like to be sure all is OK.

I am sure that it is fine.  The view is deployed through SMO and at times the columns can be rearranged under certain circumstances.  You should be fine.