Database meeda okka question

[jefferson1]

Table lo unna column names and data type ni display cheyali as a query result, ela 

ex: seqid(bigint, not null) 

idi okka column name: seqid

datatype:  bigint

 

 

[mettastar]

System tables unatyi .. nee database ento daani system tables ani google cheyi

[ekunadam_enkanna]

endi va. google skills/stack xchange skills lo training teeskuleda?

 

https://stackoverflow.com/questions/13405572/sql-statement-to-get-column-type

[Paidithalli]

19 minutes ago, mettastar said:

System tables unatyi .. nee database ento daani system tables ani google cheyi

+1

[jefferson1]

23 minutes ago, ekunadam_enkanna said:

endi va. google skills/stack xchange skills lo training teeskuleda?

 

https://stackoverflow.com/questions/13405572/sql-statement-to-get-column-type

Thanks for this link 

here is a problem with this query 

 

I get column name and date type but not data limit 

example : varchar(64), null

i am not getting value 64 as well as null 

[Paidithalli]

SELECT DISTINCT NAME FROM SYSIBM.SYSTABLES WHERE ()

Painadhi db2 ki ....

sql ki sys.tables

[Paidithalli]

13 minutes ago, jefferson1 said:

Thanks for this link 

here is a problem with this query 

 

I get column name and date type but not data limit 

example : varchar(64), null

i am not getting value 64 as well as null 

Gotcha... try like this