Okay, I've tried for like an hour to find this, and it's making me nutty. I want to filter out all .dbo tables and just see ones with my own schema. Someone please put me out of my misery, because I'm either blind or mental.
The closest thing I've found (I think) is Change View, but the "by Schema" option is grayed out.
I tested in my place, I can filter by schema in change View and choose Schema. It works fine. I use SQL Server database. Would you please tell us more information about your issue?
Thanks.
Please mark the replies as answers if they help or unmark if not.
Feedback to us
I don't know why the option was grayed out, because it's available now.
It's not quite what I was hoping for, because I still have to wade through about 50 asp and other schemas I don't ever use for my own tables. But at least I now understand how to see only tables of a particular schema.
bennyboy1973
Member
7 Points
37 Posts
VS 2010 Server Explorer Filter by Schema?
Jan 26, 2013 09:55 AM|LINK
Okay, I've tried for like an hour to find this, and it's making me nutty. I want to filter out all .dbo tables and just see ones with my own schema. Someone please put me out of my misery, because I'm either blind or mental.
The closest thing I've found (I think) is Change View, but the "by Schema" option is grayed out.
Chen Yu - MS...
All-Star
21829 Points
2513 Posts
Microsoft
Re: VS 2010 Server Explorer Filter by Schema?
Jan 29, 2013 06:58 AM|LINK
Hi,
I tested in my place, I can filter by schema in change View and choose Schema. It works fine. I use SQL Server database. Would you please tell us more information about your issue?
Thanks.
Feedback to us
Develop and promote your apps in Windows Store
bennyboy1973
Member
7 Points
37 Posts
Re: VS 2010 Server Explorer Filter by Schema?
Jan 29, 2013 01:27 PM|LINK
I don't know why the option was grayed out, because it's available now.
It's not quite what I was hoping for, because I still have to wade through about 50 asp and other schemas I don't ever use for my own tables. But at least I now understand how to see only tables of a particular schema.
Thanks.