http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=125819
select c.name
from sys.tables t
join sys.indexes i
on(i.object_id = t.object_id
and i.index_id < 2)
join sys.index_columns ic
on(ic.partition_ordinal > 0
and ic.index_id = i.index_id and ic.object_id = t.object_id)
join sys.columns c
on(c.object_id = ic.object_id
and c.column_id = ic.column_id)
where t.object_id = object_id('table_name')
Monday, September 20, 2010
How To Get Partition Key Column Name
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment