Hi Madusanka, Look in to the following stackoverflow question[1]. This might also help you. https://groups.google.com/forum/?hl=en#!searchin/h2-database/unnamed/h2-database/Lb4QdF9jkOc/2uw1pA7i0T8J
[1] - http://stackoverflow.com/questions/10008476/dropping-unique-constraint-for-column-in-h2 On Mon, May 18, 2015 at 5:52 PM, Madusanka Premaratne <[email protected]> wrote: > Hi Devs, > I need to perform a SQL table alteration to remove a foreign key which is > unnamed. As per my findings it is possible to find the automatically > assigned constraint name in mysql by using *information_schema* table [1] > > Also it is possible in mssql[2] and oracle[3] > > [1] - > http://stackoverflow.com/questions/13856946/drop-unnamed-foreign-key-in-mysql > [2] - http://www.intergr8it.net/?p=19 > [3] - > http://stackoverflow.com/questions/9008445/drop-index-or-constraint-without-knowing-its-name-for-oracle > > I tried to add a name to the existing constraint by altering the table, > but it adds a new constraint with the given name. > > Is there a way to do the same in H2/ any other way to delete > the constraint? > > Can someone advice me to do this.? > > Thanks in advance. > Madusanka > > > > -- > *Madusanka Premaratne* | Associate Software Engineer > WSO2, Inc | lean. enterprise. middleware. > #20, Palm Grove, Colombo 03, Sri Lanka > Mobile: +94 71 835 70 73| Work: +94 112 145 345 > Email: [email protected] | Web: www.wso2.com > > [image: Facebook] <https://www.facebook.com/maduzanka> [image: Twitter] > <https://twitter.com/rmmpremaratne> [image: Google Plus] > <https://plus.google.com/u/0/+MadusankaPremaratnemaduz/about/p/pub> [image: > Linkedin] <http://lk.linkedin.com/in/madusanka/> [image: Instagram] > <http://instagram.com/madusankapremaratne> [image: Skype] > <http://@rmmpremaratne> > > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Thusitha Dayaratne Software Engineer WSO2 Inc. - lean . enterprise . middleware | wso2.com Mobile +94712756809 Blog alokayasoya.blogspot.com About http://about.me/thusithathilina
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
