PradeepVallabh
SSC Eights!
Points: 987
More actions
September 1, 2010 at 11:43 pm
#146822
How to identify the Partitioned Schemas, Partition Function and indexe's on the partitioned table in a database???
Thank you,
Pradeep
Adi Cohn-120898
SSC-Dedicated
Points: 33944
September 2, 2010 at 12:49 am
#1215424
You can query the relevant dynamic management views – sys.partitions, sys.partitition_functions and sys.partition_schemas.
Adi
--------------------------------------------------------------To know how to ask questions and increase the chances of getting asnwers:http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 2, 2010 at 12:18 pm
#1215834
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply