select sysobjects.type as object_type , sysusers.name as table_owner from dbo.sysobjects , dbo.sysusers where sysobjects.type in ('V','U','S') and sysusers.uid = sysobjects.uid and sysusers.name = and sysobjects.name = select syscolumn.column_name as name, cast((if syscolumn.pkey = 'Y' then 'true' else 'false' endif) as varchar) primaryKey, cast((if syscolumn."default" is not null and (syscolumn."default" = 'autoincrement' or syscolumn."default" = 'global autoincrement') then 'true' else 'false' endif) as varchar) identity, cast((if syscolumn.nulls = 'Y' then 'true' else 'false' endif) as varchar) nullable, sysdomain.domain_name as dbdatatype , case when sysdomain.domain_name = 'date' then 26 else syscolumn.width end as "length", syscolumn."default" from syscolumn left outer join sysdomain on syscolumn.domain_id = sysdomain.domain_id , systable where syscolumn.table_id = systable.table_id and syscolumn.column_type <> 'C' and systable.table_name = and systable.table_type in ('BASE','VIEW') BASE for base tables, VIEW for views, and GBL TEMP for global temporary tables ---> order by syscolumn.column_id