Can see now that won't be a problem to assemble the create table statement
from the data in the system tables.

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]