Is there a to change the  Type property on a table?  I would like to be able
to change the Type from 'User' to 'System' through code.

Adv-thanks-ance

What do you need this for?
True system tables have object id values less than 100, and there is no way
you can create a table with such an id.

If you are only talking about what shows up in the 'type' column when you
list the objects in Enterprise Manager, you can run the procedure

exec sp_MS_marksystemobject 'mytable'

However, it would not actually be a system table, even though Enterprise
Manager lists it as such. For example, it would still show 'user table' when
using sp_help, and you would not need to set any special flags to

Show quoteHide quote

Really really slow cursor
Problem copying data from column in same table
reverse like?
Can't we use variables in OPENQUERY, FREETEXT("@searchstring")?
inserting single precision data into sql server float column