Tuesday, October 31, 2006

Renaming Of A Table...And a Headache

A silly mistake and a headache can also be the headline of this post.We took the backup of a table A to table bckup_B,then dropped A and renamed bckup_B to A.And then ran our process.Data was coming absolutely fine through a procedure.But we were getting null values in a field.And we were finding thorugh that bigggg procedures up and down to find out why that field is not getting populated.Later we have discovered that in original table ddl that field having a default value.So....The moral of the story.Alwaysss take a backup of the DDL of a table also if you are planning to drop that table later.

---: My blog is not responsible for any damages happened from the suggestion of my blog :---
Reach me at : m_a_hasim@yahoo.com

Labels:

0 Comments:

Post a Comment

<< Home