search for: char_octet_length

...2 1 <NA> <NA> 8 NA 3 10 1 <NA> <NA> 4 NA 4 10 1 <NA> <NA> 4 NA 5 2 1 <NA> <NA> 8 NA CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE ORDINAL 1 510 1 YES 1 2 NA 2 YES 2 3 NA 3 YES 3 4 NA 4 YES 4 5 NA...

...b, "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. If I change the aDataFrame to be differ...

...47 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 <NA> <NA>...