Hallo Andreas, Die Microsoft Access online Hilfe sagt nichts dazu? Viellicht findest du das n�tzlich... Standardwert d�rfte beim anlegen der Spalte mit DEFAULT feststellbar sein... Beschreibung: keine Ahnung... Aber wenn jemand es weisst w�rde mich das auch interessieren ;-)
(aus Mysql.com developer SQL documentation, nicht alles davon ist also compatibel mit Access...) http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html Diese Doku finde ich immer ganz brauchbar wenn es darum geht, SQL statements aus einem Script auszuf�hren. CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] Or: CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(] LIKE old_tbl_name [)]; create_definition: column_definition | [CONSTRAINT [symbol]] PRIMARY KEY [index_type] (index_col_name,...) | KEY [index_name] [index_type] (index_col_name,...) | INDEX [index_name] [index_type] (index_col_name,...) | [CONSTRAINT [symbol]] UNIQUE [INDEX] [index_name] [index_type] (index_col_name,...) | [FULLTEXT|SPATIAL] [INDEX] [index_name] (index_col_name,...) | [CONSTRAINT [symbol]] FOREIGN KEY [index_name] (index_col_name,...) [reference_definition] | CHECK (expr) column_definition: col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT] [[PRIMARY] KEY] [COMMENT 'string'] [reference_definition] type: TINYINT[(length)] [UNSIGNED] [ZEROFILL] | SMALLINT[(length)] [UNSIGNED] [ZEROFILL] | MEDIUMINT[(length)] [UNSIGNED] [ZEROFILL] | INT[(length)] [UNSIGNED] [ZEROFILL] | INTEGER[(length)] [UNSIGNED] [ZEROFILL] | BIGINT[(length)] [UNSIGNED] [ZEROFILL] | REAL[(length,decimals)] [UNSIGNED] [ZEROFILL] | DOUBLE[(length,decimals)] [UNSIGNED] [ZEROFILL] | FLOAT[(length,decimals)] [UNSIGNED] [ZEROFILL] | DECIMAL(length,decimals) [UNSIGNED] [ZEROFILL] | NUMERIC(length,decimals) [UNSIGNED] [ZEROFILL] | DATE | TIME | TIMESTAMP | DATETIME | CHAR(length) [BINARY | ASCII | UNICODE] | VARCHAR(length) [BINARY] | TINYBLOB | BLOB | MEDIUMBLOB | LONGBLOB | TINYTEXT | TEXT | MEDIUMTEXT | LONGTEXT | ENUM(value1,value2,value3,...) | SET(value1,value2,value3,...) | spatial_type index_col_name: col_name [(length)] [ASC | DESC] reference_definition: REFERENCES tbl_name [(index_col_name,...)] [MATCH FULL | MATCH PARTIAL] [ON DELETE reference_option] [ON UPDATE reference_option] reference_option: RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT table_options: table_option [table_option] ... table_option: {ENGINE|TYPE} = {BDB|HEAP|ISAM|InnoDB|MERGE|MRG_MYISAM|MYISAM} | AUTO_INCREMENT = value | AVG_ROW_LENGTH = value | CHECKSUM = {0 | 1} | COMMENT = 'string' | MAX_ROWS = value | MIN_ROWS = value | PACK_KEYS = {0 | 1 | DEFAULT} | PASSWORD = 'string' | DELAY_KEY_WRITE = {0 | 1} | ROW_FORMAT = { DEFAULT | DYNAMIC | FIXED | COMPRESSED } | RAID_TYPE = { 1 | STRIPED | RAID0 } RAID_CHUNKS = value RAID_CHUNKSIZE = value | UNION = (tbl_name[,tbl_name]...) | INSERT_METHOD = { NO | FIRST | LAST } | DATA DIRECTORY = 'absolute path to directory' | INDEX DIRECTORY = 'absolute path to directory' | [DEFAULT] CHARACTER SET charset_name [COLLATE collation_name] select_statement: [IGNORE | REPLACE] [AS] SELECT ... (Some legal select statement) Armelle V�rit� Software Developer Canto GmbH Alt-Moabit 59-60 10555 Berlin Germany VOX: +49 (0)30 390 48 50 FAX: +49 (0)30 390 48 55-55 email: [EMAIL PROTECTED] http://www.canto.com all digital assets. everywhere. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andreas M�ller Sent: mercredi 7 juillet 2004 12:13 To: [EMAIL PROTECTED] Subject: [Database.asp] Access DB verwalten mit ASP Hi Ich sollte per Skript diverse �nderungen in einer Access 2000 DB vornehmen lassen. Klar, es gibt tolle Admin-Tools, der Witz ist jedoch der, dass ich die nicht brauchen kann - es soll ein fertiges ASP-Skript geliefert werden, das s�mtliche Arbeiten vornimmt. Jetzt hab ich es zwar geschafft, Tabellen zu erzeugen und Felder zu �ndern, aber ich habe immer grosse Probleme die Werte f�r die Datentypen zu finden (LONG, AUTOINCREMENT, etc.). Gibt's da irgendwo eine Doku? Ausserdem: wie kann ich Standardwert und Beschreibung �ndern? Das hab' ich nirgends gefunden. Danke f�r alle Tipps. Andreas _______________________________________________ Database.asp Mailingliste, Postings senden an: [EMAIL PROTECTED] An-/Abmeldung und Suchfunktion unter: http://www.glengamoi.com/mailman/listinfo/database.asp
