[prev in list] [next in list] [prev in thread] [next in thread] 

List:       hsqldb-user
Subject:    Re: [Hsqldb-user] CREATE CUSTOM SCHEMA BY DEFAULT OTHER THAN PUBLIC
From:       Fred Toussi <fredt () users ! sourceforge ! net>
Date:       2013-06-03 14:26:20
Message-ID: 1370269580.5893.140661239207385.6AEE0EF9 () webmail ! messagingengine ! com
[Download RAW message or body]

It is SET NOT NULL

Please read the Guide.

http://www.hsqldb.org/doc/2.0/guide/databaseobjects-chapt.html#dbc_table_manupulation

Fred

On Mon, Jun 3, 2013, at 15:13, risaldeep wrote:
> Hello Fred,
>  why
> ALTER TABLE "BF_CLASS" ALTER COLUMN "ID" NOT NULL 
> this statement is giving an error like
> 
>  org.hsqldb.HsqlException: unexpected token: NOT: line: 4
> 
> plzzz any suggestion
> 
> 
> 
> --
> View this message in context:
> http://hsqldb.10974.n7.nabble.com/CREATE-CUSTOM-SCHEMA-BY-DEFAULT-OTHER-THAN-PUBLIC-tp3903p3905.html
> Sent from the HSQLDB - User mailing list archive at Nabble.com.
> 
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite
> It's a free troubleshooting tool designed for production
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://p.sf.net/sfu/appdyn_d2d_ap2
> _______________________________________________
> Hsqldb-user mailing list
> Hsqldb-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite
It's a free troubleshooting tool designed for production
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://p.sf.net/sfu/appdyn_d2d_ap2
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
[prev in list] [next in list] [prev in thread] [next in thread]