DipMeshSystems.

Firebird 技術文書
技術文書 literature music このサイトについて
Firebirdのインストール Firebird標準コマンドラインツール ibWebAdmin FlameRobin テーブル構造取得 nbackup
SELECT RR.RDB$RELATION_NAME AS TNAME, RR.RDB$DESCRIPTION AS TDESC, RRF.RDB$FIELD_POSITION AS FPOS, RRF.RDB$FIELD_NAME AS FNAME, RRF.RDB$DESCRIPTION AS FDESC, RT.RDB$TYPE_NAME AS FTYPE, RF.RDB$FIELD_LENGTH AS FBYTE, RF.RDB$CHARACTER_LENGTH AS FCHAR, RF.RDB$FIELD_PRECISION AS FPREC, RF.RDB$FIELD_SCALE AS FSCALE, RF.RDB$FIELD_SUB_TYPE AS FSUBTYPE, CASE RRF.RDB$NULL_FLAG WHEN 1 THEN 'NOT NULL' ELSE '' END AS FNULL, RRF.RDB$DEFAULT_SOURCE AS FDEF, RCHR.RDB$CHARACTER_SET_NAME AS FCSET, RCOL.RDB$BASE_COLLATION_NAME AS FCOLA FROM RDB$RELATIONS RR JOIN RDB$RELATION_FIELDS RRF ON RR.RDB$RELATION_NAME = RRF.RDB$RELATION_NAME JOIN RDB$FIELDS RF ON RRF.RDB$FIELD_SOURCE = RF.RDB$FIELD_NAME JOIN RDB$TYPES RT ON RF.RDB$FIELD_TYPE = RT.RDB$TYPE JOIN RDB$CHARACTER_SETS RCHR ON (RF.RDB$CHARACTER_SET_ID = RCHR.RDB$CHARACTER_SET_ID OR (RF.RDB$CHARACTER_SET_ID IS NULL AND RCHR.RDB$CHARACTER_SET_ID=0 ) ) JOIN RDB$COLLATIONS RCOL ON (RRF.RDB$COLLATION_ID = RCOL.RDB$COLLATION_ID OR (RRF.RDB$COLLATION_ID IS NULL AND RCOL.RDB$COLLATION_ID=0 ) ) WHERE RR.RDB$RELATION_NAME NOT LIKE '%$%' AND RT.RDB$FIELD_NAME='RDB$FIELD_TYPE' AND RCHR.RDB$CHARACTER_SET_ID = RCOL.RDB$CHARACTER_SET_ID ORDER BY RR.RDB$RELATION_NAME ASC, RRF.RDB$FIELD_POSITION ASC ;

©1998-2014 DipMeshSystems.
this site is powered by OpenSylph / DipMeshSystems.
x