The Create Table Generator generates Create Table statements. The generated statements can be executed directly on your target database to create the table, or saved to file to be executed later on a database and platform of your choice.
The following example shows create table DDL statements for a Microsoft Jet database:
create table [Customer]
(
[ID1] long UNIQUE NOT NULL,
[First Name] text (50),
[Last Name] text (50),
[House Number] text (5),
[Street] text (50),
[City] text (50),
[Post Code] text (15),
[Birth Date] datetime,
[Country] text (50),
)
CREATE INDEX PrimaryKey ON [Customer]
([ID1])
WITH PRIMARY
Figure 0.1 Example Create Table DDL statements generated by TurboData
See TurboData Scenarios Overview