System Tables 2

[sandylou]

Does anyone know how to safely delete a table from the system tables? I deleted a row for a table from the sysObjects table but failed to delete it from the subsequent tables. How can i find out all of the system tables I should remove the data from?

 

[NoCoolHandle]

Why didn't you just run [blue]Drop Table[/blue] TableName

But to answer your question

syscolumns
sysconstraints
sysindexes
syspermissions

Just to name a couple...

If you want a complete list of all system tables and how they relate to each other

http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.asp

HTH

Rob

 

[sandylou]

long story, but to sum it up, the database was hanging and i should have killed the processes, but in order to get rid of the table deleted it from the sysobjects because i couldn't get it to delete by dropping or truncating...it just froze...it ended up deleting, but the entire db froze, so i had to rebuild anyway..thank you!

 

[dbomrrsm]

Great link NoCoolHandle - a star for you.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[NoCoolHandle]

Sandy,

once you clean up your systemtables you will need to make sure that you run dbcc checkdb against the database as well as sp_spaceused (with the rebuild option what ever that is)

Just deleteing the entrys won't clean up errors in the allocation tables.

I am probably forgetting something, but expect errors

Rob

 

[pzmgmb]

Sweet link NoCoolHandle... thanks again