Aah, thanks, so I have to study some outputs from eg Workbench (nice tool
btw, the free one), look at the data in the system
tables and do some coding in my app to make the create statement from the
data in the system tables. So, I suppose the same
as you did in Delphi in Workbench?

RBS

_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: 18 December 2009 17:19
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Get create table SQL from system tables




Hello,

> Where in the system tables do I get (with a select SQL) the CREATE TABLE
> statement
> of a table that exists in the database? We are on FB 1.5.

You don't, you either use a GUI tool like Database Workbench
or another tool that creates such a statement by querying the
system tables and constructing the statement.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene <http://www.upscene.com> com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.database <http://www.databasedevelopmentforum.com>
developmentforum.com





[Non-text portions of this message have been removed]