CREATE TABLE customers; DROP TABLE customers; instead of writing code "CREATE TABLE customers;" , Can I just simply delete the "DROP TABLE customers;" and execute the procedure?

Hi Jo! Thanks for reaching out. This will depend on the state of your database at the moment of the execution of these queries. For instance, if you have already created the 'customers' table, you don't need to execute CREATE TABLE customers...; However, the following statement can lead to an error if 'customers' didn't exist at the moment of execution. DROP TABLE customers; That's why the practice requires to execute the same statement, practically, with the following addition. DROP TABLE IF EXISTS customers; What I explained so far, is valid in general. And, it could be applicable in your case, if you only referred to the lecture you indicated. However, as you will see further down the syllabus of this course, there is a type of SQL stored routines, called SQL stored procedures. If that's what you referred to, then the specificity of my answer would depend on the content of the query creating the procedure you are referring to. Hope this helps.Best,Martin

back

Follow this topic

Jo Zhou

Last answered:

April 17, 2020

Posted on:

April 14, 2020

Can we revoke DROP statement by deleting the code line

2 answers ( 0 marked as helpful)

Martin Ganchev

Posted on:

April 15, 2020

Jo Zhou

Posted on:

April 17, 2020

Submit an answer

Content