就是要获取 数据库中的分区函数和分区方案的 内容 请问用什么命令 或者其他途径 分数不多 全部放出
--分区函数
USE [Demo]
GO
/****** 对象: PartitionFunction [YEARPF] 脚本日期: 10/12/2009 11:58:12 ******/
CREATE PARTITION FUNCTION [YEARPF](datetime) AS RANGE LEFT FOR VALUES
(N'2000-01-01 00:00:00', N'2001-01-01 00:00:00', N'2002-01-01 00:00:00',
N'2003-01-01 00:00:00', N'2004-01-01 00:00:00')
--分区方案
USE [Demo]
GO
/****** 对象: PartitionScheme [YEARPS] 脚本日期: 10/12/2009 11:57:42 ******/
CREATE PARTITION SCHEME [YEARPS] AS PARTITION [YEARPF] TO
([YEARFG1], [YEARFG2], [YEARFG3], [YEARFG4], [YEARFG5], [YEARFG6
--分区函数
USE [Demo]
GO
/****** 对象: PartitionFunction [YEARPF] 脚本日期: 10/12/2009 11:58:12 ******/
CREATE PARTITION FUNCTION [YEARPF](datetime) AS RANGE LEFT FOR VALUES
(N'2000-01-01 00:00:00', N'2001-01-01 00:00:00', N'2002-01-01 00:00:00',
N'2003-01-01 00:00:00', N'2004-01-01 00:00:00')
--分区方案
USE [Demo]
GO
/****** 对象: PartitionScheme [YEARPS] 脚本日期: 10/12/2009 11:57:42 ******/
CREATE PARTITION SCHEME [YEARPS] AS PARTITION [YEARPF] TO
([YEARFG1], [YEARFG2], [YEARFG3], [YEARFG4], [YEARFG5], [YEARFG6
$partition.Account_partition(playerid) AS [Partition Number],
MIN(playerid) AS [Min playerid],
MAX(playerid) AS [Max playerid],
COUNT(playerid) AS [Rows In Partition]
FROM dbo.account AS o
GROUP BY $partition.Account_partition(playerid) with rollup
ORDER BY [Partition Number]
--分区函数
USE [Demo]
GO
/****** 对象: PartitionFunction [YEARPF] 脚本日期: 10/12/2009 11:58:12 ******/
CREATE PARTITION FUNCTION [YEARPF](datetime) AS RANGE LEFT FOR VALUES
(N'2000-01-01 00:00:00', N'2001-01-01 00:00:00', N'2002-01-01 00:00:00',
N'2003-01-01 00:00:00', N'2004-01-01 00:00:00')
--分区方案
USE [Demo]
GO
/****** 对象: PartitionScheme [YEARPS] 脚本日期: 10/12/2009 11:57:42 ******/
CREATE PARTITION SCHEME [YEARPS] AS PARTITION [YEARPF] TO
([YEARFG1], [YEARFG2], [YEARFG3], [YEARFG4], [YEARFG5], [YEARFG6两项东西
SELECT ds.name as fg_name, dds.destination_id as p_id,ps.name as ps_name FROM SYS.DATA_SPACES ds, SYS.PARTITION_SCHEMES ps, SYS.DESTINATION_DATA_SPACES dds
WHERE ds.data_space_id=dds.data_space_id AND dds.partition_scheme_id=ps.data_space_id
使用 ALTER PARTITION SCHEMA、ALTER PARTITION FUNCTION、ALTER TABLE 语句修改分区。具体如何通过程序实现,这就靠你的编成能力了:)