sql - Update foreign key column from not null to null -

-

how can update foreign key column in table not null null without having recreate table?

i tried use this:

update tblproduct  set consumerid not null

please advise, thank

did try this?

alter table [table] alter column [column] integer null

Comments

Post a Comment

Popular posts from this blog

python - cx_oracle unable to find Oracle Client -

-
i have installd python 2.7.3 on linux 64 bit machine. have oracle 11g client(64bit) installed. , set oracle_home, path, ld_library_path, , installed cx_oracle 5.1.2 version python 2.7 & oracle 11g. ldd command on cx_oracle unable find libclntsh.so.11.1. i tried creating symlinks libclntsh.so.11.1 under /usr/lib64, updated oracle.conf file under /etc/ld.so.conf.d/. tried possible solutions have been discussed on issue on forums, no luck. please let me know missing. the issue me installed python, cx_oracle root oracle client installation done "oracle" user. got own oracle installation , fixed issue. later ran pyunicodeucs4_decodeutf16 issues python , had install python —enable-unicode=ucs4 option
Read more

stringtemplate - StringTemplate4 if conditional with length -

-
i need generate following kinds of code stringtemplate4: methodfoo0(connection conn); methodfoo1(connection conn, int arg1); methodfoo2(connection conn, int arg1, int arg2); etc. the "connection conn" part present passing method name , rest of arguments st template. template looks follows: <methodname>(connection conn, <args; separator=", ">); this works produces comma when there no arguments @ (except conn): methodfoo0(connection conn,); to eliminate comma tried using if conditional , length st4 function couldn't work although tried various combos following: <methodname>(connection conn <if (length(fieldsinfind) \> 0)>,<else><endif><fieldsinfind; separator=", ">) ... , others failed parsing-related error ( mismatched input ). in end, gave , resorted passing comma parameter template either "," or empty string "" based on pre-rendering logic. you check p...
Read more

shader - OpenGL Shadow Map -

-
i trying basic shadow map reason doesn't render properly. video of problem i render house using flat shader: int shadowmapwidth = window_size_x * (int)shadow_map_ratio; int shadowmapheight = window_size_y * (int)shadow_map_ratio; // rendering shadow texture. glactivetexture(gl_texture0); call_gl(glbindtexture(gl_texture_2d, shadowtexture)); // bind framebuffer. call_gl(glbindframebuffer(gl_framebuffer, shadowfbo)); //clear call_gl(glclear(gl_depth_buffer_bit)); call_gl(glviewport(0, 0, shadowmapwidth, shadowmapheight)); call_gl(glcolormask(gl_false, gl_false, gl_false, gl_false)); //render stuff flatshader.use(); flatshader["basecolor"] = glm::vec4(1.0f,1.0f,1.0f,1.0f); flatshader["pvm"] = projectionmatrix*pointlight.viewmatrix*cursor.modelmatrix; cursor.draw(); //binds vao , draws // revert scene. call_gl(glbindframebuffer(gl_framebuffer, 0)); call_gl(glcolormask(gl_true, gl_true, gl_true, gl_true)); call_gl(glviewport(0, 0, window_size_x, window_s...
Read more