System tables are the groups of plateau that helps sql computer to road the aggregation regarding users, databases, tables, replications tasks and so whatever duty and also helps in sql ask meet same append query, withdraw sql query, update sql query,. All aggregation regarding database that is knows by sql computer are in grouping tables. These grouping tables are fortuity downbound into computer groups.
1) The officer databases include aggregation regarding databases, logins, computer and whatever grouping panoramic information.
2) Each accumulation humble contains whatever plateau which holds aggregation on objects, indexes, columns and whatever database information.
3) The MSDB database contains a ordered of tables that utilised by SQL SERVER Agent which accumulation aggregation on alerts, jobs and others items that manages by agents.
4) The MSDB contains aggregation regarding patronage and change information.
5) The officer database contains a ordered of tables that stop study of business and subscribing servers.
6) The organisation database contains aggregation on copy schedules and transactions.
7) The databases that move in copy objects with in those databases.
There are nearly 100 of grouping tables and whatever examples of queries are here:Sql Server 2000 ask on systems tables:
1) To intend study of direct files from grouping plateau database
Selectname, study from sysdatabases
2) How t intend study of every files utilised by database with the support of Sql Server 2000 queries
Select name, study from sysfiles.
Some examples of grouping tables
Sysaltfiles
Syscolumns
Master database
To stop databases
In apiece database
Column information
If you poverty to undergo the whole database study then the ask is:
Select * from sysobjects where xype = ‘U’ visit by study
No comments:
Post a Comment