show column name in a table

[yehlu]

https://stackoverflow.com/questions/165 ... es-columns

代碼: 選擇全部

select COLUMN_NAME
from SUNRISECT.information_schema.columns
where TABLE_NAME = 'MAN'
order by table_name, ordinal_position