操作系统
无法初始化性能监控器数据区;服务器启动继续
Sybase IQ
Version 16.0
(64bit mode)
Copyright 1992-2013 by Sybase, Inc. All rights reserved
[中-Copyright ? [中-2013] [中-SAP AG or an SAP affiliate company.]]
[中-All rights reserved.]
对本软件的使用受 Sybase 许可协议的约束。
请访问 http://www.sybase.com/softwarelicenses。
检测到的处理器: 1
[中-Maximum number of processors the server will use: 1 physical processor(s), 1 core(s)]
在 Windows 7 Build 7601 Service Pack 1 上运行 X86_64
为 X86_64 处理器体系结构建立的服务器
49152K 内存用于高速缓存
最小高速缓存大小: 49152K,最大高速缓存大小: 262144K
使用 4096 字节的最大页面大小
多道程序设计级别: 25
已禁用自动调整多道程序设计级别
数据库服务器因启动错误而关闭
Sybase IQ/16.0.0.429/130316/P/GA/MS/Windows 2003/64bit/2013-03-16 21:30:09
Sybase IQ/16.0.0.429/130316/P/GA/MS/Windows 2003/64bit/2013-03-16 21:30:09
select * from syscolumn;
相关的sql语句信息
select
t1.OWNER as 库,
t1.table_name as 表名,
t3.COMMENTS as 表注释,
t1.column_name as 列名,
t1.data_type as 数据类型,
case when t1.data_type='NUMBER' and data_scale='0' and t1.data_precision is null then 'INTEGER'
when t1.data_type='NUMBER' and data_scale='0' and t1.data_precision is not null then 'NUMBER'
else t1.data_type end as 处理数据类型 ,--排除 integer整形的部分
case when t1.data_type='NUMBER' and data_scale<>'0' then 'NUMBER'||'('||t1.data_precision||','||t1.data_scale||')' --data_precision 代表精度 如果为null表示总长度不固定
when t1.data_type='NUMBER' and data_scale='0' and t1.data_precision is null then 'INTEGER'
when t1.data_type='NUMBER' and data_scale='0' and t1.data_precision is not null then 'NUMBER'||'('||t1.data_precision||')'
when t1.data_type='NUMBER' and data_scale is null then 'NUMBER'
when t1.data_type='DATE' then 'DATE' --DATE 不要直接读取长度
when t1.data_type='TIMESTAMP(0)' then 'TIMESTAMP(0)'
when t1.data_type='TIMESTAMP(6)' then 'TIMESTAMP(6)'
else t1.data_type || '(' || t1.data_length || ')'
end as 源数据类型,
case when t1.data_type='CHAR' then 'VARCHAR2'||'('||t1.data_length||')'
when t1.data_type='NUMBER' and data_scale<>'0' then 'NUMBER'||'('||t1.data_precision||','||t1.data_scale||')' --data_scale 代表精度 data_length 代表长度
when t1.data_type='NUMBER' and data_scale='0' and t1.data_precision is null then 'NUMBER' --number 和精度为0的部分 特殊处理成intger
when t1.data_type='NUMBER' and data_scale='0' and t1.data_precision is not null then 'NUMBER'||'('||t1.data_precision||')'
when t1.data_type='NUMBER' and data_scale is null then 'NUMBER'
when t1.data_type='DATE' then 'DATE' --DATE 不要直接读取长度
when t1.data_type='TIMESTAMP(0)' then 'TIMESTAMP(0)'
when t1.data_type='TIMESTAMP(6)' then 'TIMESTAMP(6)'
else t1.data_type || '(' || t1.data_length || ')'
end as 转换数据类型,
t2.comments as 列备注,
t1.COLUMN_ID
from all_TAB_COLUMNS t1
left join ALL_COL_COMMENTS t2
on t1.OWNER = t2.OWNER
and t1.table_name = t2.table_name
and t1.column_name = t2.column_name
left join (select a.OWNER,a.table_name, a.comments
from all_tab_comments a
where table_name not like 'BIN$%'
group by a.OWNER,a.table_name, a.comments) t3
on t1.owner=t3.OWNER
and t1.table_name=t3.TABLE_NAME
where t1.OWNER in('CFMSDATA')
order by t1.table_name,t1.COLUMN_ID