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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-10-26 : 03:20:19
|
| GurusCan you please give me a example where we can use information_schema to obtain the information?please helpregardsNitin |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-10-26 : 03:21:41
|
[code]use Northwindselect COLUMN_NAMEfrom INFORMATION_SCHEMA.COLUMNSwhere TABLE_NAME = 'Orders'order by ORDINAL_POSITION[/code]
KH |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-10-26 : 05:57:22
|
| select specific_name from information_schema.routines where schema_definition like '%Nitin%'it returns waht are all the procedures contain ur name in a specific databaseKrishna |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-10-26 : 07:28:02
|
quote:
Originally posted by nitin1353
GurusCan you please give me a example where we can use information_schema to obtain the information?please helpregardsNitin
Well, its depends on which kind of information you want to view.Look into BOL, under information_schema you will get many type of view's and their purpose.Chiraghttp://chirikworld.blogspot.com/ |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-10-27 : 08:56:59
|
| Thanks Krishna,khtan and chiragRegardsNitin |
|
|
|
|
|
|
Information schema