#Sql navigator tutorial code

When the SAP HANA developer activates CDS file (Core Data Services) a corresponding runtime object (a database catalog object) is created in the current database schema. When an ABAP programmer creates a CDS document, a SQL DDL source file with.

#Sql navigator tutorial code

To create database objects on SAP HANA database, ABAP developers will use SQL DDL afterwards.ĬDS stands for Core Data Services in SAP HANA database terminology.ĬDS documents are design-time source code files showing the definition and SQL DDL source of the database objects SAP HANA developers want to create. Now with SAP HANA, ABAP programmers can create DDL objects like SQL Views, Stored Procedures, User-Defined Functions (skalar functions or table valued functions) on database level. SQL Server developers use Transact-SQL, Oracle developers use PL/SQL for DDL and DML tasks. The transactions taking place on a database table, like inserting a new row, or updating data in a table, deleting data from table, MERGE commands are Data Manipulation Language commands, aka DML statements.

On the other hand, DDL commands are directly related with data itself. Using an appropriate SQL DDL command database professionals can alter existing database objects or delete them ,too.īackup or restore operations, and many other SQL commands related with database tasks rather then tasks with manipulating data are SQL DDL statements. In database terminology, DDL stands for Data Definition Language which differs from DML, Data Manipulation Language.Īs you can guess, SQL DDL or SQL Data Definition Language commands enables developers and database administrators to manage metadata operations like creating database objects including tables, views, function, stored procedures, etc.