03.04.2015 11:15, Alex Peshkoff wrote: > Agree with this logic, but it will be useful to add a warning, i.e. > > SQL> create table t(a notnull); > SQL> alter table t alter a drop not null; > Warning: Column a based on not null domain > SQL> > > Or something like this, may be text is not ideal.
Column is always based on domain. If it is auto-generated domain, ALTER TABLE can drop constraint from it without problem. -- WBR, SD. ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
