What are system views in sql server

Posted by Sekar.C under Sql Server on 3/27/2012 | Points: 10 | Views : 608 | Status : [Member] | Replies : 3
hi,
What are system views in sql server?

Regards
Sekar.c

Regards
Sekar.c



Responses

Posted by: CGN007 on: 3/27/2012 [Member] Silver | Points: 25

Up
0
Down
Hi,
In SQL Server, there are a few system databases like Master, Temp, msdb, and tempdb. Each and every database has its own responsibility, like Master data is one of the template databases for all the databases which are created in SQL Server 2005. Similarly, System Views are predefined Microsoft created Views that already exist in the Master database. These are also used as template Views for all new databases. These system Views will be automatically inserted into any user created database. There are around 230 system Views available.
Please refer this http://www.codeproject.com/Articles/38560/Overview-of-View-in-SQL-Server-2005


Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/19/2012 [Member] Starter | Points: 25

Up
0
Down

SELECT * FROM INFORMATION_SCHEMA.VIEWS

REGARDS
SRIRAM.R

sriram

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Akiii on: 6/2/2012 [Member] Bronze | Points: 25

Up
0
Down
Good explanation @CGN007 !


Regards
Akiii

Sekar.C, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response