Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dorffius
Starting Member
36 Posts |
 Posted - 2002-04-22 : 13:17:24
|
| Is there a way to delete all the data from a column while leaving the column information and the rest of the table alone? |
|
|
Radhika
Starting Member
15 Posts |
Posted - 2002-04-22 : 13:24:45
|
| There is no Delete command for a specific column in a table. The immediate thing that strikes my head is :1. Does that column have NULL constraint applied on it? If Yes, then use the UPDATE Statement to update thic column to NULL leaving the other columns uneffected. UPDATE tablename SET ColName = NULL 2. Or is the column set to NOT NULL COntraint but has a default value Set? If Yes, then alo use the update statement to ste it to the default value UPDATE tablename SET ColName = defaultvalue |
 |
|
|
|
|
|
Delete * data from column???