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
  2. Madhivanan Moderator

    select
    * from master.sys.objects where type='S'
  3. Madhivanan Moderator

    <<
    when i queired select * from informatin_schema_tables
    i got only 5 tables.....
    >>
    Really? You must have got a systax error [;)]
  4. ashish287 New Member

    select
    * from sysobjects
    where xtype = 'u' or xtype = 's'
  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.

Share This Page