Results 1 to 8 of 8

Thread: sys tables

  1. #1
    Join Date
    Aug 2004
    Posts
    28

    Unanswered: sys tables

    Dear Members

    What are basically sys tables and what they do basically and why they are by-default created when any database is created?

    Regards
    Praveen Kumar Pandey

    CoVisible Solutions [I] Pvt. Ltd. CRM and Knowledge Managemet Channel

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The information used by SQL Server 2000 and its components is stored in special tables known as system tables. There are certain system tables that exists in master database and few other tables are in user database whenever its created.


    For you I suggest to refer the Books online which is installed alongwith SQL Server for complete information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Feb 2004
    Posts
    492
    Sys-tables are the system tables that sqlserver uses to store information about the database, tables, logins, locks etc.

  4. #4
    Join Date
    Aug 2004
    Posts
    28

    Thanks Satya

    Hello Satya

    First thing first Thank You for your prompt reply, One more question is there that can user delete or modify these tables.

    Regards
    Praveen Kumar Pandey

    Offshore Outsourcing - CoVisible Solutions India Prviate Limited

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    My advice is don't try it. If you succeed in deleting sys tables, odds are good that you'll make the database completely unusable.

    -PatP

  6. #6
    Join Date
    Aug 2004
    Posts
    28

    One more question

    Hello Pat

    Thaks for reply and giving the advice , but one more question is that can we modify its data

    Regards
    Praveen Kumar Pandey

    CoVisible Solutions India Private Limited - Offshore Outsourcing

  7. #7
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    In any case modifying SYSTEM TABLES must be refrained, and also querying against them when the pre-supplied stored procedures/views are available.

    Moreover these system tables will be small in size and will not be any issue, without them you cannot function SQL Server processess.
    Refer to books online for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by praveenppandey
    Thaks for reply and giving the advice , but one more question is that can we modify its data[/URL]
    Yes, you can as long as there is NO data anywhere in that database that you need.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •