SAP HANA Basics For Developers: Part 5.4 Tables and Views Via SQL DDL

This series is based upon SAP HANA on premise and SAP HANA, express edition - HANA 2.0 with XSA and SAP Web IDE for SAP HANA. Originally recorded in January 2019.

While Core Data Services is good for abstracted database modeling (and for service and UI modeling as we will see later), it doesn’t give us access to HANA specific features or data types. When performing HANA Native Development, you often are doing so specifically for such features. Therefore most of your database modeling is probably better served to be done via HANA specific artifacts rather than CDS when you want such HANA specific development. In this video we will see how to use the SQL DDL (data definition language) design time artifacts. We will retain all the lifecycle management benefits of a design time based approach we used with CDS in the past but instead use the HANA SQL based syntax for the definition of the objects.