System tables

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Alan
    #1

    System tables

    Do you know where the system tables for a database are stored ? On which
    file ?


    Tags: None
    • Erland Sommarskog
      #2
      Re: System tables

      Alan (alanpltse@yaho o.com.au) writes:[color=blue]
      > Do you know where the system tables for a database are stored ? On which
      > file ?[/color]

      They are stored in the primary file for the database. That is the same
      file you have the data.


      --
      Erland Sommarskog, SQL Server MVP, sommar@algonet. se

      Books Online for SQL Server SP3 at
      Microsoft SQL Server
      http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
      SQL Server 2025 redefines what's possible for enterprise data. With developer-first features and integration with analytics and AI models, SQL Server 2025 accelerates AI innovation using the data you already have.

        Comment

        Previous template Next
        Working...