search for: sql_data_type

...2 Murder 8 DOUBLE 53 8 NA 3 Assault 4 INTEGER 10 4 0 4 UrbanPop 4 INTEGER 10 4 0 5 Rape 8 DOUBLE 53 8 NA NUM_PREC_RADIX NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB 1 NA 1 <NA> <NA> 12 NA 2 2 1 <NA> <NA> 8 NA 3 10 1 <NA> <NA> 4 NA 4 10 1 <NA> <NA>...

...d on channel If I do sqlColumns(db, "test") it returns [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME COLUMN_NAME DATA_TYPE [6] TYPE_NAME PRECISION LENGTH SCALE RADIX [11] NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB [16] CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE DISPLAY_SIZE FIELD_TYPE <0 rows> (or 0-length row.names) But there is no test table defined anywhere else but the X schema. If I do sqlSave(db,aDataFrame,"X.test",T,F), it says test already defined...

...text 2147483647 2147483647 NA 7 H41 dbo v_MAFiles UpdatedBy 12 varchar 60 60 NA 8 H41 dbo v_MAFiles UpdatedDateTime 93 datetime 23 16 3 NUM_PREC_RADIX NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTET_LENGTH ORDINAL_POSITION 1 NA 0 <NA> <NA> 1 NA 3 1 2 NA 0 <NA> <NA> -9 NA NA 2 3 NA 0 &lt...