How to view table structure in db2

db2How to view the table structure?

DB2 is a series of relational database management systems produced by IBM, which serve on different operating system platforms.

Although DB2 products are based on UNIX systems and personal computer operating systems, DB2 pursues ORACLE database products based on UNIX systems and Microsoft's Access under windows systems.

Query means to search, search means to find what you want in one or several places;

DB2 queries the table structure definition like Oracle's desc

select * from sysibm.syscolumns where tbname = < table name>
describe select * from <table name>
或者 describe table <table name>

The above is the detailed content of How to view table structure in db2. For more information, please follow other related articles on the PHP Chinese website!