Delete Non System Table

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • wsrinivas
    New Member
    • Jul 2006
    • 10

    Delete Non System Table

    Bu Mistake our DTS has selected the Masters Database while performing a Data Transfer

    can you please suggest how do I delete Non-System Tables from the masters database.

    Your help is appriciated
  • AJ2
    New Member
    • Aug 2006
    • 6

    #2
    in sysobjects table looking for "U" in xtype column (U: user table, S: system table).

    Comment

    Working...