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 |
|
Jude_Aj
Starting Member
22 Posts |
 Posted - 2009-12-31 : 07:42:33
|
| Hi, i am using sql server 2000 .I have a table with four columns ie. col1,col2,col3 and col4.I have records in the table .I used dbcc page command and i could see the values of all the column.I then deleted a column , col2, from the table and did dbcc page again.I could see the values of all the columns except for col2 which value "Dropped" (The record structure was still the same).I understand that the column information are stored in "syscolumn" tableHowever the record for col2 was not found(for obvious reason).I am wondering in which system table can i find the information the col2 is deleted.Where is this information stored?Thanks,Jude |
|
|
Jude_Aj
Starting Member
22 Posts |
Posted - 2009-12-31 : 07:43:09
|
| heres the dump of the record using dbcc command.00000000: 10001800 01000000 02000000 03000000 †................ 00000010: 04000000 05000000 0500e0†††††††††††††........... Slot 0 Column 0 Offset 0x4 Length 4Col1 = 1 Slot 0 Column 1 Offset 0x8 Length 4DROPPED = 2 Slot 0 Column 2 Offset 0xc Length 4Col3 = 3 Slot 0 Column 3 Offset 0x10 Length 4Col4 = 4 Slot 0 Column 4 Offset 0x14 Length 4Col5 = 5 here as you can see,col2 is marked as "dropped"There as to be a place where the information that col2 is deleted is stored.Thanks. |
 |
|
|
|
|
|
Identifying deleted columns