如何用SQL语句获取创建分区函数和分区架构的语句

SELECT

	SchemaName = S.name,

	TableName = TB.name,

	PartitionScheme = PS.name,

	PartitionFunction = PF.name,

	PartitionFunctionRangeType = CASE

			WHEN boundary_value_on_right = 0 THEN 'LEFT'

			ELSE 'RIGHT' END,

	PartitionFunctionFanout = PF.fanout,

	SchemaID = S.schema_id,

	ObjectID = TB.object_id,

	PartitionSchemeID = PS.data_space_id,

	PartitionFunctionID = PS.function_id

FROM sys.schemas S

	INNER JOIN sys.tables TB

		ON S.schema_id = TB.schema_id

	INNER JOIN sys.indexes IDX

		on TB.object_id = IDX.object_id

			AND IDX.index_id < 2

	INNER JOIN sys.partition_schemes PS

		ON PS.data_space_id = IDX.data_space_id

	INNER JOIN sys.partition_functions PF

		ON PS.function_id = PF.function_id