MS SQL Server - How to mark a system table as a user table so I can script it out ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to mark a system table as a user table so I can script it out ?

Hassan

2005-05-21, 3:23 am

Is there a hack to mark a system table to a user table.. This is just for
testing and is not in any of the sys databases..

Cristian Lefter

2005-05-21, 3:23 am

You can script a system table using Query Analyzer: "Right click - Script
Object to "new windows"/"file"/"clipboard" as create"
Cristian Lefter, SQL Server MVP

"Hassan" <fatima_ja@hotmail.com> wrote in message
news:O3ePEtaXFHA.3864@TK2MSFTNGP10.phx.gbl...
> Is there a hack to mark a system table to a user table.. This is just for
> testing and is not in any of the sys databases..
>
>

Sponsored Links