![]() ![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |