no information on character_maximum_length and is_identity in unity catalog table system.information_schema.columns

table definition example

CREATE TABLE tyable_name (

 UniqueID bigint not null GENERATED ALWAYS AS IDENTITY , 

 ID varchar(256)

)

looks like the columns table only has basic info such as data type

-- query column info

select *

from system.information_schema.columns

where table_name ='<table>' and table_catalog ='<catalog>'