Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jude_Aj
Starting Member
22 Posts |
 Posted - 2009-06-10 : 02:59:55
|
| Hi, Is there any way i can view the schema of the system views in SQL server 2005.Thanks |
|
|
Nageswar9
Aged Yak Warrior
600 Posts |
Posted - 2009-06-10 : 03:01:29
|
| is this u want?select * from sys.objects where type = 'v' |
 |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-06-10 : 03:04:47
|
| select * from information_Schema.views select * from sys.views |
|
|
|
Jude_Aj
Starting Member
22 Posts |
Posted - 2009-06-10 : 03:06:00
|
| No, i was looking for the "query" of the system views, as in "create view sys,sysindexes...." |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-10 : 03:59:01
|
sp_helptext 'viewname here'
E 12°55'05.63"N 56°04'39.26" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-06-10 : 04:20:04
|
| Make use of the resultselect 'EXEC sp_helptext '''+name+'''' from sys.viewsMadhivananFailing to plan is Planning to fail |
|
|
|
Jude_Aj
Starting Member
22 Posts |
Posted - 2009-06-10 : 08:48:21
|
| Thanks that solved the problem!! |
|
|
|
|
|
|
get system view schema