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 |
|
binary
Starting Member
6 Posts |
 Posted - 2008-11-11 : 12:51:10
|
| hellocan we quey a system table to see all objects belonging to a specific schema under sql 2005, for exemple i want to see all objects belonging to humanressource schema...thank you |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-11 : 13:02:18
|
| select so.name from sys.objects soinner join sys.schemas scon sc.schema_id = so.schema_idwhere sc.name = 'Humanresources'and so.type ='U' |
 |
|
|
|
|
|
schema sql 2005