Data type range values using any SQL query

Question

I was referring to Java Constant Field Values and thought if boundary values ( say MIN_VALUE, MAX_VALUE in case of Numeric data types ) can be retrieved for data types using an SQL query.

For example

select  
    int.signed_min_value as int_sgnd_min,  
    int.unsigned_min_value as int_usgnd_min,  
    int.signed_max_value as int_sgnd_max,  
    int.unsigned_max_value as int_usgnd_max,  
    int.storage_bytes as int_bytes  
from dual;

Should be resulting

+--------------+---------------+--------------+---------------+-----------+
| int_sgnd_min | int_usgnd_min | int_sgnd_max | int_usgnd_max | int_bytes |
+--------------+---------------+--------------+---------------+-----------+
|  -2147483648 |             0 |   2147483647 |    4294967295 |       4   |
+--------------+---------------+--------------+---------------+-----------+

Above results are storage and range values defined for MySQL integer data type.
Other data type storage requirements in MySQL are as defined here.

I gave a sample on numeric data type only but I am also expecting a possibility for other data types.

I do am aware that we can only select columns and expressions, but trying to understand if there is such a facility in SQL like in Java and other programming languages.

@Diego Well, no constraint. Generic is appreciated.

Ravinder Reddy
– Ravinder Reddy

2012-07-05 14:12:06 +00:00
Commented Jul 5, 2012 at 14:12 — Ravinder Reddy
– Ravinder Reddy, Commented Jul 5, 2012 at 14:12

Diego · Accepted Answer · 2012-07-05 14:15:08Z

1

if you mean Sql Server, you can get that info from the sys.types table. If you do:

select * from sys.types
where name='int'

you can check the max_length, which indicates the Maximum length (in bytes) of the type. So int = 4 bites whihc gives you -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)

answered Jul 5, 2012 at 14:15

Diego

36.5k21 gold badges94 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ravinder Reddy Over a year ago

In SQL Server, how do I get range values if name='date'? AFAIK, Oracle date ranges from January 1, 4712 BC to December 31, 9999 AD

Collectives™ on Stack Overflow

Data type range values using any SQL query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related