Page History: Table Definitions - AS/400

Compare Page Revisions

0 Current 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Tue, Nov 14, 2023, 6:46 AM

select 
     ordinal_position as Seq
    ,column_name as Col
    ,data_type as DataType
    ,character_maximum_length as MaxLen
    ,numeric_precision as Prec
    ,numeric_scale as Scale 
from 
    INFORMATION_SCHEMA.COLUMNS 
where 1=1
    and table_schema = 'MVXBDTA002' 
    and table_name = 'OINACC'
order by
    Seq