资源描述：
《INFORMIX查询标准表结构SQL》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、--规范SQLselecta.tabnameastabname_en,''tabname_cn,b.colno,b.colnameascolname_en,''colname_cn,caseb.coltypewhen'0'then'varchar2('
2、
3、collength
4、
5、')'when'1'then'integer'when'2'then'integer'when'3'then'float'when'4'then'float'when'5'then'decimal('
6、
7、trunc(collength/256)
8、
9、','
10、
11、mod(collength,256)
12、
13、')'when
14、'6'then'integer'when'7'then'date'when'8'then'money'when'9'then'null'when'10'then'datetime'when'11'then'byte'when'12'then'text'when'13'then'varchar2('
15、
16、collength
17、
18、')'when'14'then'interval'when'15'then'varchar2('
19、
20、collength
21、
22、')'when'16'then'varchar2('
23、
24、collength
25、
26、')'when'17'then'int8'when'18'then
27、'serial8'when'19'then'set'when'20'then'multiset'when'21'then'list'when'22'then'unnamedrow'when'40'then'varchar2(4000)'when'41'then'clob'when'43'then'blob'when'44'then'boolean'when'256'then'varchar2('
28、
29、collength
30、
31、')'when'257'then'integer'when'258'then'integer'when'259'then'float'when'260'then're
32、al'when'261'then'decimal('
33、
34、trunc(collength/256)
35、
36、','
37、
38、mod(collength,256)
39、
40、')'when'262'then'serial'when'263'then'date'when'264'then'money'when'266'then'datetime'when'267'then'byte'when'268'then'text'when'269'then'varchar'when'270'then'interval'when'271'then'varchar2('
41、
42、collength
43、
44、')'when'272'th
45、en'varchar2('
46、
47、collength
48、
49、')'when'273'then'int8'when'274'then'serial8'when'275'then'set'when'276'then'multiset'when'277'then'list'when'278'then'unnamedrow'when'296'then'lvarchar'when'297'then'clob'when'298'then'blob'when'299'then'boolean'when'4118'then'namedrow'endascoltypename,casewhenc.idxtyp
50、e='U'then'Y'else'N'endasKEY_TYPE,casewhenb.coltype>=256then'N'else'Y'endasNULL_TYPEfromsystablesaleftjoinsyscolumnsbona.tabid=b.tabidleftjoinsysindexescona.tabid=c.tabidandb.colnoin(c.part1,c.part2,c.part3,c.part4,c.part5,c.part6,c.part7,c.part8)andidxtype='U'wherea.tabid>99anda.tabtype='T'ANDa
51、.tabname=‘test’orderbya.tabname,b.colno
