gen. include file for column definitions??
From: Dietmar Leibecke <dleibeck_at_debis.com.--->
Date: 1997/10/07
Message-ID: <343A5758.6445_at_debis.com.--->#1/1
Date: 1997/10/07
Message-ID: <343A5758.6445_at_debis.com.--->#1/1
Hi there,
[Quoted] I'm looking for a way to generate a C include file with the column length definitions of all varchar fields in a database. The result should look like
#define MAX_<TABLENAME>_<COLNAME> <COLUMNLENGTH>+1
where TABLENAME is the name of the table, COLNAME the name of the column and COLUMNLENGTH the length of the varchar field.
Does such a tool already exist or is there a simple SELECT to retrieve the information needed?
Any input welcome and TIA,
-- Dietmar Leibecke ---------------- Address is altered to discourage junk mail. Remove ".---" for the real address.Received on Tue Oct 07 1997 - 00:00:00 CEST