Firebird 存储过程 字段信息
摘要:CREATE PROCEDURE ProGetColumnInfo(TableName varchar(50))returns (TableCode VARCHAR(50),FIELDNAME VARCHAR(20),ID INT,TYPENAME VARCHAR(20),LEN INT,SCALE int, SUBTYPE INT,IsPrimary INT)ASbegin FOR SELECT a.RDB$RELATION_NAME, b.RDB$FIELD_NAME , b.RDB$FIELD_ID , d.RDB$TYPE_NAME , c.RDB$FIELD_LENGTH/2...
阅读全文
posted @ 2012-07-19 16:39
浙公网安备 33010602011771号