SQLScript_for_SAP_HANA
Additional scripts and information about the english edition of the book SQLScript for SAP HANA. Please note that the German edition of the book has a slightly different demo data model. The scripts are not compatible, because the names of the tables, functions and procedures are different.
Installation of the Demo Data Model
Behind the following links are the SQL scripts that create the data model and fill it with data. Please copy the contents of the individual scripts to the clipboard and then open an SQL console for the database schema of your choice, for example the personal schema of your database user. There you insert the script and execute it.
- Creating Database Tables
- Creating Procedures and Functions
- Filling Database Tables - Part 1
- Filling Database Tables - Part 2
- Check installation
After each script, please check in the console output whether everything ran without errors. The last script queries the number of lines in the respective tables. This allows you to check whether the data was loaded correctly.
You can also save the script files locally and customize them as you like. If, for example, the test data is too much for you, you can simply adapt the corresponding script. To delete the created database objects, there is also a suitable script:
Deleting Database Tables, Procedures, and Functions
Overview of the Demo Data Model
