sql - H2 database: is it possible to rename a constraint? -

-

is there way rename constraint in h2 database?

same question one: sql server rename constraint?, h2 database.

no, can not, there no sql statement in the grammar of h2 can it.

so need create new constraint , drop old one.


Comments

Post a Comment

Popular posts from this blog

Load Balancing in Bluemix using custom domain and DNS SRV records -

-
i'm trying load balancing of application in bluemix using custom domain , srv record in dns manager. created own doamin ccbluemix.dynu.com , added custom domain bluemix. created application in region , created route custom domain myapp.ccbluemix.dynu.com deployed same application in uk region , created route custom domain myapp.ccbluemix.dynu.com there well. now whenever user hits route want load balancing between , uk region alternate requests served , uk regions. for created srv records like _http._tcp.ccbluemix.dynu.com srv eu-gb.mybluemix.net [priority: 0] [weight: 50] 10 _http._tcp.ccbluemix.dynu.com srv mybluemix.net [priority: 0] [weight: 50] 10 but nothing happening , i'm not able access application using custom route @ all. if create 'a' record cc-load-bal-app.ccbluemix.dynu.com 75.126.81.68 i can access app using custom route ends hitting server. how can achieve load balancing using srv records? wrong creating srv records here? i read ne...
Read more

oracle - pls-00402 alias required in select list of cursor to avoid duplicate column names -

-
my cursor : select xzis.msisdn msisdn, xzis.in_account_number in_account_number xxobw_zte_in_sync xzis not exists (select 1 hz_contact_points hcp, hz_cust_accounts hca hcp.owner_table_id = hca.party_id , hcp.owner_table_name = 'hz_parties' , hcp.phone_number = substr (xzis.msisdn, -8) , nvl (hca.attribute12, 'nil') = xzis.in_account_number); i have given alias columns, still facing issue. suggestions? it's cursor. 1 has no such problems. problem is, when you're joining 2 tables, or apply wrong aliases in subselect, cursor may @ end return 2 columns same name/alias. the problem not need alias, no 2 columns can have same alias (the name counting alias, when no alias given). apparently has happened, far can tell, it's ...
Read more

python - Apache Thrift Tutorial Error -

-
i've been trying learn use apache thrift in python following tutorial: http://www.billdimmick.com/devjournal/building-an-apache-thrift-service-in-python.html . thrift file used tutorial is: namespace py demo service mathservice { i64 add(1: i64 a, 2: i64 y) } when try compile python code thrift --gen py:new_style demo.thrift following error: [error:/home/pi/programming/python/thrift-tutorial/demo.thrift:4] (last token '{') syntax error [failure:/home/pi/programming/python/thrift-tutorial/demo.thrift:4] parser error during include pass i can't see wrong thrift file i'm still getting errors. what's wrong?
Read more