Hi Sriram. 1) Here's a worklog related to your project: WL#3129: Consistent clauses in CREATE and DROP https://dev.mysql.com/worklog/ 2) Maybe you can do a follow-on GSOC next year on this worklog: WL#5047: SQL command class hierarchy. There's lots of low-hanging fruit enhancing SQL options, yet at the same time very useful to end-users. 3) You can see my notes and references for adding new MySQL commands here: Howto Add a New Command to the MySQL Server http://www.jebriggs.com/blog/2013/05/howto-add-a-new-command-to-the-mysql-se... James. -------------------------------------------- On Thu, 3/20/14, sriram patil <spsrirampatil@gmail.com> wrote: Subject: Re: [Maria-developers] [GSOC 2014] "CREATE OR REPLACE, CREATE IF NOT EXISTS, and DROP IF EXISTS" Project To: "James Briggs" <james.briggs@yahoo.com> Cc: maria-developers@lists.launchpad.net Date: Thursday, March 20, 2014, 5:34 AM Hi James, Replying again cause the text did not appear in the mailing list. Sure, I will try and implement that feature too. Thank you very much for the suggestion. Thanks, Sriram On Thu, Mar 20, 2014 at 4:02 AM, James Briggs <james.briggs@yahoo.com> wrote: Hi Sriram. If you could add "CREATE VIEW … FORCE" too, that would be awesome. See the Oracle Enterprise docs for the behavior: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8004.htm Thanks, James.