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 |
|
hrishi_des
Yak Posting Veteran
76 Posts |
 Posted - 2006-12-01 : 05:01:17
|
| Given the name of partition table how to find programmatically which column the table is partitioned on? |
|
|
hrishi_des
Yak Posting Veteran
76 Posts |
Posted - 2006-12-01 : 05:18:57
|
| Many thanks for a quick reply but can u please elobarate how to find partition column from this??? |
 |
|
|
hrishi_des
Yak Posting Veteran
76 Posts |
Posted - 2006-12-01 : 07:16:45
|
| found it! Sys.Index_columns catalog has a column partition_ordinal which can be used. |
|
|
|
|
|
|
How to find Partition Column Name