In the Entity System entity you will find the physical names of the entities (no pun intended).
This naming format is to allow complex environments where several eSpaces have entities with the same name and also due to Oracle table name limitations.
You might also want to take a look into these posts:
- Entity to physical table mapping
- Configuring the physical table name format for Entities
You can get the SQL upgrade script if you do a step by step publish of your eSpace in Service Center
This will get you the changes from the previous version. To get the complete ddl of the eSpace you might need to use a third party SQL tool (e.g. SQL Server Management Studio)