Power Builder - Vaciar una bd Adaptive Server Anywhere

Deseo vaciar mi bd (SQL Adaptive Server Anywhere), y poner los valores de las claves primarias en cero(dichas claves están en autoincremental). Como se cambian esos valores? Gracias a todos,desde ya.

Hola

Prueba esto
es por tablas-

string ls_reset
String Tabla

Tabla = Trim(sle_1.Text)

ls_reset = "Truncate TABLE " + Tabla

EXECUTE IMMEDIATE :ls_reset ;

Saludos y Mucha suerte

Saludos...

El utility de Anywhere para descargar la BD se llama 'dbunload'...

dbunload [ switches ] [ directory ]

Switch Description
-ac "keyword=value; ..." Connect to the database specified in the connect string to do the reload.
-an database Creates a database file with the same settings as the database being unloaded, and automatically reloads it.
-c "keyword=value; ..." Supply database connection parameters
-d Unload data only
-e list No data output for listed tables
-ii Internal unload, internal reload (default)
-ix Internal unload, external reload
-j nnn Repeated unload of view creation statements
-n No data—schema definition only
-o file Log output messages to file
-p char Escape character for external unloads (default "")
-q Quiet mode—no windows or messages
-r reload-file Specify name and directory of generated reload Interactive SQL command file (default reload.sql)
-t list Output only the listed tables
-u Unordered data
-v Verbose messages
-xi External unload (when client and server are on different machines), internal reload
-xx External unload (when client and server are on different machines), external reload
-y Replace the command file without confirmation
directory The directory where the unloaded data is to be placed. Not needed for -an or -ac.