![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio XE6 (Delphi Win32) » SQL Reference » ALTER TABLE Statement |
ALTER TABLE [IF EXISTS] table_reference [[ADD [COLUMN] [IF NOT EXISTS] column_name data type [dimensions] [AT column_position] [DESCRIPTION column description] [NULLABLE][NOT NULL] [DEFAULT default value] [MIN or MINIMUM minimum value] [MAX or MAXIMUM maximum value] [CHARCASE UPPER | LOWER | NOCHANGE] [COMPRESS 0..9]] | [REDEFINE [COLUMN] [IF EXISTS] column_name [new_column_name] data type [dimensions] [AT column_position] [DESCRIPTION column description] [NULLABLE][NOT NULL] [DEFAULT default value] [MIN or MINIMUM minimum value] [MAX or MAXIMUM maximum value] [CHARCASE UPPER | LOWER | NOCHANGE] [COMPRESS 0..9]] | [DROP [COLUMN] [IF EXISTS] column_name]] [, ADD [COLUMN] column_name REDEFINE [COLUMN] column_name DROP [COLUMN] column_name...] [, ADD [CONSTRAINT constraint_name] [UNIQUE] [NOCASE] PRIMARY KEY (column_name [ASC or ASCENDING | DESC or DESCENDING] [, column_name...]) [COMPRESS DUPBYTE | TRAILBYTE | FULL | NONE]] [NOKEYSTATS] [, REDEFINE [CONSTRAINT constraint_name] [UNIQUE] [NOCASE] PRIMARY KEY (column_name [ASC or ASCENDING | DESC or DESCENDING] [, column_name...]) [COMPRESS DUPBYTE | TRAILBYTE | FULL | NONE]] [NOKEYSTATS] [, DROP [CONSTRAINT constraint_name] PRIMARY KEY] [TEXT INDEX (column_name, [column_name])] [STOP WORDS space-separated list of words] [SPACE CHARS list of characters] [INCLUDE CHARS list of characters] [DESCRIPTION table_description] [INDEX PAGE SIZE index_page_size] [BLOB BLOCK SIZE BLOB_block_size] [LOCALE locale_name | LOCALE CODE locale_code] [ENCRYPTED WITH password] [USER MAJOR VERSION user-defined_major_version] [USER MINOR VERSION user-defined_minor_version] [LAST AUTOINC last_autoinc_value] [NOBACKUP]
ALTER TABLE Names DROP FullName, ADD IF NOT EXISTS LastName CHAR(25)
ALTER TABLE Names REDEFINE LastName CHAR(30)
ALTER TABLE Customer TEXT INDEX ()
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |