jua_java Posted September 22, 2015 Report Posted September 22, 2015 Guys can some tell how to get count of cols in a db2 table !! Dba prevs lekunda
ramudu3 Posted September 22, 2015 Report Posted September 22, 2015 LTT P.s: try this Select distinct(name), ColType, Length from Sysibm.syscolumns where tbname = 'new_table_name';
vasu123 Posted September 23, 2015 Report Posted September 23, 2015 Guys can some tell how to get count of cols in a db2 table !! Dba prevs lekunda Man GUI vachaka queries enduku, just click on table and right side tabs like data, columns, ddl anni untay kada sql developer lo, columns tab meeda nokkithe count tho saha untay, just see last number of column and ur answer is there. We dont need any commands or query when we have GUI Oracle ok. But db2 not sure
mastikaraja Posted September 23, 2015 Report Posted September 23, 2015 column or rows ? via schema browser u can see the name's of the column's though .
jua_java Posted September 23, 2015 Author Report Posted September 23, 2015 Bro db2 ki teradata sql assistant vadatamu ikkada tht has no such option
Recommended Posts