Given a view can i check, using a query or stored procedure, if it is a
partitioned view or not ?
thanks
Vivek T S
Member Technical Staff (Inucom)
select objectproperty(object_id('myview'),'isindexed')
1 for true
0 for false
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Vivek T S" <VivekTS@.discussions.microsoft.com> wrote in message
news:2D4F830B-BB6C-4EBC-A2D9-D1F6C6C03DC0@.microsoft.com...
> Given a view can i check, using a query or stored procedure, if it is a
> partitioned view or not ?
> thanks
> --
> Vivek T S
> Member Technical Staff (Inucom)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment