Karen

  ALTER TABLE tblName ALTER colName DROP DEFAULT

 

Buddy

 

 

From: karentellef via RBASE-L <[email protected]> 
Sent: Tuesday, May 22, 2018 11:26 AM
To: [email protected]
Subject: [RBASE-L] - Dropping a default?

 

Is there a way to drop a column's default value in code?    We have a routine 
that runs overnight to do structure changes and I want to drop a default value 
for a column.  I know I can drop and recreate the column, but then I have to 
make sure that I've saved a copy of the original values because they might have 
changed them, and then bring in that data.

 

Karen

 

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected] 
<mailto:[email protected]> .
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to