SQL Server 中的 DEFAULTS 关键字

顾名思义,在创建表、要素类、栅格数据集以及索引时,默认情况下使用 DEFAULTS 配置关键字下的设置。如果在地理数据库中创建数据时未指定其他关键字,或者指定的关键字缺少某些必要参数,则将使用 DEFAULTS 关键字中的值。

对于归属于 DEFAULTS 关键字的参数,所设置的参数值应适用于地理数据库中的多数数据。如果未对 SDE_dbtune 表进行自定义,则在该表中将显示以下值。

##DEFAULTS  NUM_DEFAULT_CURSORS	-1 CROSS_DB_QUERY_FILTER  0 UI_TEXT	"User Interface text for DEFAULTS" A_CLUSTER_ROWID	0 A_CLUSTER_SHAPE	1 A_CLUSTER_STATEID	0 A_CLUSTER_USER	0 A_CLUSTER_XML  0 A_CLUSTER_RASTER  0 A_INDEX_ROWID	"WITH FILLFACTOR = 75" A_INDEX_SHAPE	"WITH FILLFACTOR = 75" A_INDEX_STATEID	"WITH FILLFACTOR = 75" A_INDEX_USER	"WITH FILLFACTOR = 75" A_INDEX_XML	"WITH FILLFACTOR = 75" A_INDEX_RASTER	"WITH FILLFACTOR = 75" A_MS_SPINDEX    "GRIDS = (MEDIUM, MEDIUM, MEDIUM, MEDIUM), CELLS_PER_OBJECT = 16" A_OUT_OF_ROW   0 A_STORAGE	"" B_CLUSTER_ROWID	0 B_CLUSTER_SHAPE	1 B_CLUSTER_USER	0 B_CLUSTER_XML 0 B_CLUSTER_RASTER 0 B_INDEX_ROWID	"WITH FILLFACTOR = 75" B_INDEX_SHAPE	"WITH FILLFACTOR = 75" B_INDEX_USER	"WITH FILLFACTOR = 75" B_INDEX_XML	"WITH FILLFACTOR = 75" B_INDEX_RASTER	"WITH FILLFACTOR = 75" B_INDEX_TO_DATE "WITH FILLFACTOR = 75" B_MS_SPINDEX    "GRIDS = (MEDIUM, MEDIUM, MEDIUM, MEDIUM), CELLS_PER_OBJECT = 16" B_STORAGE	"" B_OUT_OF_ROW   0 D_CLUSTER_ALL	0 D_CLUSTER_DELETED_AT	1 D_INDEX_ALL	"WITH FILLFACTOR = 75" D_INDEX_DELETED_AT	"WITH FILLFACTOR = 75" D_STORAGE	"" F_CLUSTER_FID	1 F_INDEX_AREA	"WITH FILLFACTOR = 75" F_INDEX_FID	"WITH FILLFACTOR = 75" F_INDEX_LEN	"WITH FILLFACTOR = 75" F_STORAGE	"" F_OUT_OF_ROW   0 S_CLUSTER_ALL	1 S_CLUSTER_SP_FID	0 S_INDEX_ALL	"WITH FILLFACTOR = 75" S_INDEX_SP_FID	"WITH FILLFACTOR = 75" S_STORAGE	"" RAS_STORAGE       "" RAS_CLUSTER_ID   1 RAS_INDEX_ID    "WITH FILLFACTOR = 75" BND_STORAGE       "" BND_CLUSTER_ID   0 BND_INDEX_ID    "WITH FILLFACTOR = 75" BND_CLUSTER_COMPOSITE   0 BND_INDEX_COMPOSITE    "WITH FILLFACTOR = 75" AUX_STORAGE       "" AUX_CLUSTER_COMPOSITE   1 AUX_INDEX_COMPOSITE    "WITH FILLFACTOR = 75" BLK_STORAGE       "" BLK_CLUSTER_COMPOSITE   1 BLK_INDEX_COMPOSITE    "WITH FILLFACTOR = 75" BLK_OUT_OF_ROW   0 XML_DOC_INDEX	"WITH FILLFACTOR = 75" XML_DOC_STORAGE	"" XML_DOC_OUT_OF_ROW	0 XML_DOC_UNCOMPRESSED_TYPE	"BINARY" XML_IDX_CLUSTER_DOUBLE	0 XML_IDX_CLUSTER_ID			0 XML_IDX_CLUSTER_PK			1 XML_IDX_CLUSTER_STRING	0 XML_IDX_CLUSTER_TAG		0 XML_IDX_FULLTEXT_CAT		"SDE_DEFAULT_CAT" XML_IDX_FULLTEXT_LANGUAGE XML_IDX_FULLTEXT_TIMESTAMP	1 XML_IDX_FULLTEXT_UPDATE_METHOD 		"CHANGE_TRACKING BACKGROUND" XML_IDX_INDEX_DOUBLE	"WITH FILLFACTOR = 75" XML_IDX_INDEX_ID		"WITH FILLFACTOR = 75" XML_IDX_INDEX_PK		"WITH FILLFACTOR = 75" XML_IDX_INDEX_STRING	"WITH FILLFACTOR = 75" XML_IDX_INDEX_TAG	"WITH FILLFACTOR = 75" XML_IDX_STORAGE XML_IDX_OUT_OF_ROW	0 GEOM_SRID_CHECK			1 GEOMETRY_STORAGE       "SDEBINARY" GEOMTAB_OUT_OF_ROW	0 GEOMTAB_PK				"WITH FILLFACTOR = 75" GEOMTAB_STORAGE		"" PERMISSION_CACHE_THRESHOLD  250 UNICODE_STRING   "TRUE" COLLATION_NAME   "" XMLCOLUMN_STORAGE			"DB_XML" XMLCOLUMN_SCHEMA	"" XMLCOLUMN_TYPE			"" XMLCOLUMN_PRIMARY_IDX	0 XMLCOLUMN_PATH_IDX		    0 XMLCOLUMN_PROPERTY_IDX	0  XMLCOLUMN_VALUE_IDX	 	0  RASTER_STORAGE   "BINARY"  END

相关主题


3/7/2012