1. SQLite will not inform you about the value ranges, only about the base type.
2. Scott provided a great way for you to do exactly what you want (if efficiency of transfer is your real goal as understood from your last post).
3. The forum uses "Markdown" formatting (if you select it as such above the edit box). Google "markdown" for some more info on that, but here are the basics:
To include a quote, simply precede it with the greater-than sign: >
Again, it has to be the first character on a new-new-line, so if I type: > this is a quote, but on a new-new line, it looks like this:
> this is a quote
Code can be formatted by (among others) enclosing in three back-ticks or tilde signs after a new-line which itself follows a new-line (let's call it a new-new-line), so if I start a piece of text on a new line after a new-new-line by ``` or ~~~ , any text that follows will be formatted as mono-space code text until the next such 3 characters are found. For example, the next section is code:
```
SELECT 1, 2, 3
FROM myTable
WHERE id = 5
;
```
And now back to normal.
Happy learning!