July 30, 2018 at 11:08 pm
Comments posted to this topic are about the item Drop table in one shot
July 30, 2018 at 11:09 pm
Nice question, thanks Carlo
Particularly enjoyed some of the wrong answers...
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
July 31, 2018 at 1:52 am
Sorry, thought answer 2 was some sort of psuedo code.
Bit of a strange question.
July 31, 2018 at 4:00 am
Good question, thanks!
July 31, 2018 at 5:54 am
Nice Question Carlo 🙂
---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know
July 31, 2018 at 6:10 am
paul s-306273 - Tuesday, July 31, 2018 1:52 AMSorry, thought answer 2 was some sort of psuedo code.
Bit of a strange question.
No, it isn't
for answer 2 to work, it should have been DROP TABLE IF EXISTS b,a;
you can test it as follows:DROP TABLE IF EXISTS b,a;
CREATE TABLE a
(
i INT PRIMARY KEY
);
CREATE TABLE b
(
i INT PRIMARY KEY
FOREIGN KEY REFERENCES a
);
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
July 31, 2018 at 6:17 am
Thanks for the clarification on option 2!!!
July 31, 2018 at 6:50 am
Interesting question, Carlo. Thanks.
I did not know that I could drop more than one table with a single statement. At first blush, it seems like something that could lead to confusion or mistakes and that should not be encouraged.
July 31, 2018 at 12:07 pm
Interesting, really interesting. Thanks, Carlo!
July 31, 2018 at 12:54 pm
Kaye Cahs - Tuesday, July 31, 2018 6:50 AMInteresting question, Carlo. Thanks.I did not know that I could drop more than one table with a single statement. At first blush, it seems like something that could lead to confusion or mistakes and that should not be encouraged.
If you know the syntax no confusion at all!
July 31, 2018 at 12:59 pm
Carlo Romagnano - Tuesday, July 31, 2018 12:54 PMKaye Cahs - Tuesday, July 31, 2018 6:50 AMInteresting question, Carlo. Thanks.I did not know that I could drop more than one table with a single statement. At first blush, it seems like something that could lead to confusion or mistakes and that should not be encouraged.
If you know the syntax no confusion at all!
Exactly. That's why I found it 'really interesting.' I am looking forward to your next post(s).
July 31, 2018 at 5:16 pm
Very nice and interesting question. Thanks Carlo.
August 1, 2018 at 8:41 am
Carlo Romagnano - Tuesday, July 31, 2018 12:54 PMKaye Cahs - Tuesday, July 31, 2018 6:50 AMInteresting question, Carlo. Thanks.I did not know that I could drop more than one table with a single statement. At first blush, it seems like something that could lead to confusion or mistakes and that should not be encouraged.
If you know the syntax no confusion at all!
...and I didn't know that "IF EXISTS" could only be mentioned once (and would apply to the entire list of objects), so I thought option 2 (in addition to option 4) would work. Thanks for the question!
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply