retrive deleted column

moein serpico

hi guys i delete a column in a table UNWITTING how can i restore my mistake and retrieved my deleted column

Dalek Dave

Ctrl Z ? How's the new job?

------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]

Simon_Whale

if it had data in it then restore from backup.

As barmey as a sack of badgers

MidwestLimey

You can't per se, the data is gone. However as Simon said you can restore from the last backup. S??? happens, that's what backups are for. If this is a production DB on the otherhand, s??? should rarely happen to them, which means an awfull lot of arselicking would be required. If there are no backups, divert blame to the DBA as s??? happens and that's what backups should be for. If you are the DBA, and no backups have been performed, and this was the dev environment, copy the production environment to dev. If you are the DBA, and no backups have been performed, and this was the production environment find the nearest exit and polish your resume. Good luck!

062142174041062102

SimulationofSai

If you do not know how to help, shut up. And provided you can read and comprehend "Insults, slap-downs and sarcasm aren't welcome. Let's work to help developers, not make them feel stupid."

SG Aham Brahmasmi!

PIEBALDconsult

SimulationofSai wrote:

"Insults, slap-downs and sarcasm aren't welcome.

Yes they are... as long as they're directed at someone else.

Dalek Dave

You need to develop a sense of humour and read earlier threads, ass hat.

------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]

Corporal Agarn

Sorry I did not see this sooner, so this is too late. Depending on your disaster recovery model you could do a point in time restore from your backup. This would mean you need full recovery mode, and using the transaction logs.

Qulan

If this is production AND you have a backup, you may not want to restore over the top of a production database. you can instead restore to a new database, then add the column allowing nulls, use an update query to put the data back leaving anything in the other columns unchanged. depends on the nature of your data and environment.