sybase

AlterColumnSQL not supported

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               DECIMAL(10) NOT NULL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname VARCHAR(250),
price            DECIMAL(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT GetDate(),
BIGFELLOW        VARCHAR(250),
TS               DATE,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON KUTU.testtable (firstname, lastname);
CREATE INDEX idx2 ON KUTU.testtable (price, lastname);
ALTER TABLE KUTU.testtable ADD height           DECIMAL(32,8);
ALTER TABLE KUTU.testtable ADD weight           DECIMAL(32,8);

mysql

CREATE DATABASE KUTU;
DROP TABLE IF EXISTS KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID               INTEGER NOT NULL AUTO_INCREMENT,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) NOT NULL DEFAULT 'Chen',
averylonglongfieldname LONGTEXT,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           TIMESTAMP,
BIGFELLOW        LONGTEXT,
TS               TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
)TYPE=ISAM;
ALTER TABLE KUTU.testtable ADD  FULLTEXT INDEX idx  (firstname, lastname);
ALTER TABLE KUTU.testtable ADD  INDEX idx2  (price, lastname);
ALTER TABLE KUTU.testtable ADD height           DOUBLE;
ALTER TABLE KUTU.testtable ADD weight           DOUBLE;
ALTER TABLE KUTU.testtable MODIFY COLUMN height           DOUBLE NOT NULL;
ALTER TABLE KUTU.testtable MODIFY COLUMN weight           DOUBLE NOT NULL;

access

Warning: Access does not supported DEFAULT values (field FIRSTNAME) Warning: Access does not supported DEFAULT values (field LASTNAME) Warning: Access does not supported DEFAULT values (field price) Warning: Access does not supported DEFAULT values (field MYDATE) Warning: Access does not supported DEFAULT values (field TS) AlterColumnSQL not supported

DROP TABLE testtable;
CREATE TABLE testtable (
ID               COUNTER,
FIRSTNAME        VARCHAR(30),
LASTNAME         VARCHAR(28) NOT NULL,
averylonglongfieldname MEMO,
price            NUMERIC(7,2),
MYDATE           DATETIME,
BIGFELLOW        MEMO,
TS               DATETIME,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON testtable (firstname, lastname);
CREATE INDEX idx2 ON testtable (price, lastname);
ALTER TABLE testtable ADD height           DOUBLE;
ALTER TABLE testtable ADD weight           DOUBLE;

oci8

CREATE USER KUTU IDENTIFIED BY tiger;
/
GRANT CREATE SESSION, CREATE TABLE,UNLIMITED TABLESPACE,CREATE SEQUENCE TO KUTU;
/
DROP TABLE KUTU.testtable CASCADE CONSTRAINTS;
/
drop sequence KUTU.seq_testtable;
/
CREATE TABLE KUTU.testtable (
ID               DECIMAL(10) NOT NULL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname VARCHAR(4000),
price            DECIMAL(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT TRUNC(SYSDATE),
BIGFELLOW        VARCHAR(4000),
TS               DATE DEFAULT SYSDATE,
                 PRIMARY KEY (ID, LASTNAME)
)TABLESPACE USERS;
/
DROP SEQUENCE KUTU.SEQ_testtable;
/
CREATE SEQUENCE KUTU.SEQ_testtable;
/
CREATE OR REPLACE TRIGGER KUTU.TRIG_SEQ_testtable BEFORE insert ON KUTU.testtable FOR EACH ROW BEGIN select KUTU.SEQ_testtable.nextval into :new.ID from dual; END;;
/
CREATE BITMAP INDEX idx ON KUTU.testtable (firstname, lastname);
/
CREATE INDEX idx2 ON KUTU.testtable (price, lastname);
/
ALTER TABLE testtable ADD (
 height           DECIMAL,
 weight           DECIMAL);
/
ALTER TABLE testtable MODIFY(
 height           DECIMAL NOT NULL,
 weight           DECIMAL NOT NULL);
/

postgres

AlterColumnSQL not supported for PostgreSQL

CREATE DATABASE KUTU LOCATION='/u01/postdata';
DROP TABLE KUTU.testtable;
drop sequence KUTU.testtable_m_id_seq;
CREATE TABLE KUTU.testtable (
ID               SERIAL,
FIRSTNAME        VARCHAR(30) DEFAULT 'Joan',
LASTNAME         VARCHAR(28) DEFAULT 'Chen' NOT NULL,
averylonglongfieldname TEXT,
price            NUMERIC(7,2) DEFAULT 0.00,
MYDATE           DATE DEFAULT CURRENT_DATE,
BIGFELLOW        TEXT,
TS               TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx ON KUTU.testtable USING HASH (firstname, lastname);
CREATE INDEX idx2 ON KUTU.testtable (price, lastname);
ALTER TABLE KUTU.testtable ADD COLUMN height           FLOAT8;
ALTER TABLE KUTU.testtable ADD COLUMN weight           FLOAT8;