Search This Blog

System Tables

MASTER .. SYSTABLES


1. The sysaltfiles table contains a list of files on the server.

2. The syscacheobjects table shows you how SQL Server is using its cache.

3. The syscharsets table designates which character sets and sort orders are available to SQL Server.

4. The sysconfigures table contains an entry for each configuration option set in SQL Server.

5. The syscurconfigs table is identical to the sysconfigures table.

6. The sysdatabases table contains a list of the databases installed on your SQL Server.

7. The syslanguages table contains a list of languages installed on the SQL Server.

8.The syslockinfo table contains information about all granted, waiting, and converting locks.

9. The syslogins table contains a list of logins that are assigned to the server.

10.The sysmessages table contains a list of the available error and informational messages installed on the SQL Server.

11.The sysoledbusers table contains a record for each user used for linked servers.

12.The sysperfinfo database contains a list of performance counters used when monitoring SQL Server in System Monitor.

13.The sysprocesses table contains a list of the system and user processes currently running on the server.

14.The sysservers table contains a record for the local server as well as any linked servers or servers participating in replication.


LOCAL .. SYSTABLES


1. SysColumns

2. SysComments

3. SysConstraints

4. The sysfilegroups table includes a table for each file group used by your database

5. The sysfiles table contains a record for each data and log file used in a given database

6. The sysforeignkeys table contains information for any foreign keys a table may use.

7. The sysfulltextcatalogs table lists all the full-text catalogs in a given database.

8. The sysindexes table contains a indexes installed in a given table.

9. The sysmembers table maps user names to a database role.

10.The sysobjects table contains a record for each database object in it.

11.The syspermissions provides a matrix of permissions assigned to the users, groups, or roles of a given database.

12.The sysprotects table expands on the syspermissions table and specifies which type of permissions the user has.

13.The sysreferences table shows the relationships between the tables.

14.The systypes table contains a list of system and user-defined data types.

15.The sysusers table contains a list of users and roles in a given database





No comments: