Are Stored Procedures DDL or DML?

Asked Feb 28 '17 at 22:43

Active Nov 20 '18 at 22:12

Viewed 8,134 times

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.

edited Nov 20 '18 at 22:12

asked Feb 28 '17 at 22:43

Marco Vargas

1,074
9
27

3

A stored procedure is *created* using DDL, but can _contain_ DML and DDL – a_horse_with_no_name 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 – a_horse_with_no_name 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

Are Stored Procedures DDL or DML?

0 Answers0