Shulou(Shulou.com)05/31 Report--

Editor to share with you how to query the table structure from the db2 database. I hope you will gain something after reading this article. Let's discuss it together.

SELECT

A.TABNAME,a.REMARKS,b.NAME, b.REMARKS, b.COLTYPE, b.LENGTH, b.SCALE,b.NULLS

FROM

Syscat.tables a

SYSIBM.SYSCOLUMNS b

WHERE

A.TABSCHEMA = 'HBTS'

AND a.TYPE ='T'

AND a.TABNAME = b.TBNAME

After reading this article, I believe you have a certain understanding of "how to query table structure from db2 database". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.