SQL Server Performance

system tables in master database

Discussion in 'SQL Server 2005 General DBA Questions' started by y.koteswarrao, Jun 17, 2010.

  1. y.koteswarrao New Member

    what the system tables available in the master database in sqlserver 2005? i know that in sqlserver 2005 system tables are hidden,i want to know that available tables in master database?
    when i queired select * from informatin_schema_tables
    i got only 5 tables.....
    Please provide the information
    koteswarrao
    y.koteswarrao, Jun 17, 2010
    #2

  2. Madhivanan Moderator

    select
    * from master.sys.objects where type='S'
    Madhivanan, Jun 18, 2010
    #3

  3. Madhivanan Moderator

    <<
    when i queired select * from informatin_schema_tables
    i got only 5 tables.....
    >>
    Really? You must have got a systax error [;)]
    Madhivanan, Jun 18, 2010
    #4

  4. ashish287 New Member

    select
    * from sysobjects
    where xtype = 'u' or xtype = 's'
    ashish287, Jun 23, 2010
    #5

  5. satya Moderator

    LOL, there is significant difference from 2000 to 2005 on what you want to get list of system tables.
    BOL confirms that: Many of the system tables from earlier releases of SQL Server are now implemented as a set of views. These views are known as compatibility views, and they are meant for backward compatibility only. The compatibility views expose the same metadata that was available in SQL Server 2000. However, the compatibility views do not expose any of the metadata related to features that are introduced in SQL Server 2005 and later.
    satya, Jun 21, 2010
    #6

Share This Page