我们是否可以选择一个适合做分区的字段和日期作为表的分区键？

如果表 PartitionTable 已分区，以下查询将返回一个或多个行。  如果表未分区，则不返回任何行。  SELECT * FROM sys.partitions AS p  JOIN sys.tables AS t  ON p.object_id = t.object_id  WHERE p.partition_id IS NOT NULL  AND t.name = 'PartitionTable';  以下查询返回表的分区列的名称。  PartitionTable.  SELECT t.object_id AS Object_ID, t.name AS TableName, ic.column_id as PartitioningColumnID, c.name AS PartitioningColumnName  FROM sys.tables AS t  JOIN sys.indexes AS i  ON t.object_id = i.object_id  JOIN sys.columns AS c  ON t.object_id = c.object_id  JOIN sys.partition_schemes AS ps  ON ps.data_space_id = i.data_space_id  JOIN sys.index_columns AS ic  ON ic.object_id = i.object_id AND ic.index_id = i.index_id AND ic.partition_ordinal > 0  WHERE t.name = 'PartitionTable'  AND i.type <= 1  AND c.column_id = 1;

答案来源网络，供参考，希望对您有帮助