"  DECLARE @tablename nvarchar(60), @constraintname nvarchar(60)\n"+
"  DECLARE @tablename nvarchar(256), @constraintname nvarchar(256)\n"+
    public void testColumnTypes() throws Exception    {        assertEqualsIgnoringWhitespaces(            "SET quoted_identifier on;\n"+            "SET quoted_identifier on;\n"+            "IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'coltype')\n"+            "BEGIN\n"+            "  DECLARE @tablename nvarchar(60), @constraintname nvarchar(60)\n"+            "  DECLARE refcursor CURSOR FOR\n"+            "  SELECT object_name(objs.parent_obj) tablename, objs.name constraintname\n"+            "    FROM sysobjects objs JOIN sysconstraints cons ON objs.id = cons.constid\n"+            "    WHERE objs.xtype != 'PK' AND object_name(objs.parent_obj) = 'coltype'  OPEN refcursor\n"+            "  FETCH NEXT FROM refcursor INTO @tablename, @constraintname\n"+            "  WHILE @@FETCH_STATUS = 0\n"+            "    BEGIN\n"+            "      EXEC ('ALTER TABLE '+@tablename+' DROP CONSTRAINT '+@constraintname)\n"+            "      FETCH NEXT FROM refcursor INTO @tablename, @constraintname\n"+            "    END\n"+            "  CLOSE refcursor\n"+            "  DEALLOCATE refcursor\n"+            "  DROP TABLE \"coltype\"\n"+            "END;\n"+            "SET quoted_identifier on;\n"+            "CREATE TABLE \"coltype\"\n"+            "(\n"+            "    \"COL_ARRAY\"           IMAGE,\n"+            "    \"COL_BIGINT\"          DECIMAL(19,0),\n"+            "    \"COL_BINARY\"          BINARY(254),\n"+            "    \"COL_BIT\"             BIT,\n"+            "    \"COL_BLOB\"            IMAGE,\n"+            "    \"COL_BOOLEAN\"         BIT,\n"+            "    \"COL_CHAR\"            CHAR(15),\n"+            "    \"COL_CLOB\"            TEXT,\n"+            "    \"COL_DATALINK\"        IMAGE,\n"+            "    \"COL_DATE\"            DATETIME,\n"+            "    \"COL_DECIMAL\"         DECIMAL(15,3),\n"+            "    \"COL_DECIMAL_NOSCALE\" DECIMAL(15,0),\n"+            "    \"COL_DISTINCT\"        IMAGE,\n"+            "    \"COL_DOUBLE\"          FLOAT,\n"+            "    \"COL_FLOAT\"           FLOAT,\n"+            "    \"COL_INTEGER\"         INT,\n"+            "    \"COL_JAVA_OBJECT\"     IMAGE,\n"+            "    \"COL_LONGVARBINARY\"   IMAGE,\n"+            "    \"COL_LONGVARCHAR\"     TEXT,\n"+            "    \"COL_NULL\"            IMAGE,\n"+            "    \"COL_NUMERIC\"         NUMERIC(15,0),\n"+            "    \"COL_OTHER\"           IMAGE,\n"+            "    \"COL_REAL\"            REAL,\n"+            "    \"COL_REF\"             IMAGE,\n"+            "    \"COL_SMALLINT\"        SMALLINT,\n"+            "    \"COL_STRUCT\"          IMAGE,\n"+            "    \"COL_TIME\"            DATETIME,\n"+            "    \"COL_TIMESTAMP\"       DATETIME,\n"+            "    \"COL_TINYINT\"         SMALLINT,\n"+            "    \"COL_VARBINARY\"       VARBINARY(15),\n"+            "    \"COL_VARCHAR\"         VARCHAR(15)\n"+            ");\n",            createTestDatabase(COLUMN_TEST_SCHEMA));    }