sapdb

Notice: Use of undefined constant ODBC_BINMODE_RETURN - assumed 'ODBC_BINMODE_RETURN' in /var/www/html/osakond/opilaste_tood/bakalaureuse_ja_diplomitood/2007_kevad/Margo_Poolak/liivakast/adodb/adodb.inc.php on line 4066 Notice: Use of undefined constant SQL_CUR_USE_DRIVER - assumed 'SQL_CUR_USE_DRIVER' in /var/www/html/osakond/opilaste_tood/bakalaureuse_ja_diplomitood/2007_kevad/Margo_Poolak/liivakast/adodb/adodb.inc.php on line 4066 Strict Standards: Declaration of ADODB2_sapdb::AlterColumnSQL() should be compatible with ADODB_DataDict::AlterColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /var/www/html/osakond/opilaste_tood/bakalaureuse_ja_diplomitood/2007_kevad/Margo_Poolak/liivakast/adodb/datadict/datadict-sapdb.inc.php on line 119 Strict Standards: Declaration of ADODB2_sapdb::DropColumnSQL() should be compatible with ADODB_DataDict::DropColumnSQL($tabname, $flds, $tableflds = '', $tableoptions = '') in /var/www/html/osakond/opilaste_tood/bakalaureuse_ja_diplomitood/2007_kevad/Margo_Poolak/liivakast/adodb/datadict/datadict-sapdb.inc.php on line 119 Strict Standards: Declaration of ADODB2_sapdb::_CreateSuffix() should be compatible with ADODB_DataDict::_CreateSuffix($fname, $ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint) in /var/www/html/osakond/opilaste_tood/bakalaureuse_ja_diplomitood/2007_kevad/Margo_Poolak/liivakast/adodb/datadict/datadict-sapdb.inc.php on line 119

CREATE DATABASE KUTU;
DROP TABLE KUTU.testtable;
CREATE TABLE KUTU.testtable (
ID                       INTEGER NOT NULL DEFAULT SERIAL,
FIRSTNAME                VARCHAR(30) DEFAULT 'Joan',
LASTNAME                 VARCHAR(28) NOT NULL DEFAULT 'Chen',
averylonglongfieldname   LONG,
price                    FIXED(7,2) DEFAULT 0.00,
MYDATE                   DATE DEFAULT DATE,
BIGFELLOW                LONG,
TS                       TIMESTAMP DEFAULT TIMESTAMP,
                 PRIMARY KEY (ID, LASTNAME)
);
CREATE INDEX idx_name ON KUTU."KUTU.testtable" (FIRSTNAME, LASTNAME);
CREATE INDEX idx_date ON KUTU."KUTU.testtable" (MYDATE);
CREATE INDEX idx ON KUTU.testtable (price, firstname, lastname);
CREATE INDEX idx2 ON KUTU.testtable (price, lastname);
ALTER TABLE KUTU.testtable ADD (height FLOAT(38), weight FLOAT(38));
ALTER TABLE KUTU.testtable MODIFY (height FLOAT(38) NOT NULL, weight FLOAT(38) NOT NULL);

sapdb

ALTER TABLE KUTU.table DROP ("my col", "col2_with_Quotes", A_col3, "col3(10)");

CREATE TABLE KUTU.adoxyz (
LASTNAME                 VARCHAR(32)
);

sybase