Mot-clé DEFAULTS dans SQL Server

Comme son nom l'indique, les paramètres associés au mot clé de configuration DEFAULTS sont ceux utilisés par défaut lors de la création de tables, de classes d'entités, de jeux de données raster et d'index. Si vous ne spécifiez pas d'autre mot-clé lors de la création de données dans la géodatabase ou si vous spécifiez un mot-clé avec des paramètres requis absents, les valeurs du mot-clé DEFAULTS sont utilisées.

Les paramètres regroupés sous le mot-clé DEFAULTS doivent être définis sur des valeurs s'appliquant à la plupart des données de votre géodatabase. Si vous ne personnalisez pas la table SDE_dbtune, elle contient les valeurs suivantes.

##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

Rubriques connexes


7/10/2012