6

Where DDL and DML are basically:

  • DDL = Data Definition Language
  • DML = Data Manipulation Language

I have always classified Stored Procedures as DDL since they uses Structured Query language.

But recently I was debated that Stored Procedures should be DML or should belong to a different classification since they internally have DDL and DML.

I searched in Internet and I didn't find any trustful documentation where Stored Procedures are classified as DDL, then I couldn't argue more...

Therefore, the question is simple: Are Stored Procedures DDL? or DML?

Edited This question has been marked as deleted, which I am partially agree, but the issue is that other questions just explains what is DDL vs DML, but there is any documentation that classify where Stored Procedures should be classified.

Marco Vargas
  • 1,232
  • 13
  • 31
  • 3
    A stored procedure is *created* using DDL, but can _contain_ DML and DDL –  Feb 28 '17 at 22:50
  • Agree with you, but do you have any link or documentation that indicates that? – Marco Vargas Feb 28 '17 at 22:54
  • All manuals for all DBMS –  Mar 01 '17 at 06:44
  • Thanks but by chance could you please point me to one of this manuals... I know it is a matter of common sense, but I need to provide proofs, documentation, manuals, or something... and I google it and didn't find anything were explicitly say stored procedures are DDL – Marco Vargas May 05 '17 at 23:26

0 Answers0