Re: Relations / ForeignKeys - Primay Key Now supported

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by Dave on June 27 2007 22:15:49:

In Reply to: Re: Relations / ForeignKeys posted by Dave on March 18 2005 07:03:04:

PRIMARY KEY is now supported since version 1.6.0.14.

Known sources to provide Primary Key info is : MySql, MS SQL Server, and most Jet OLEDB supported Files (like Access).
If more than one key is found, and target SQL support only one Primary Key per table, Only first key found will be kept.

Dave.

> Udo,
>
> SQL Script Builder do not support datatable-relations or constraints, because it do not support any other statement than the column type.
>
> NOT NULL, NOT NULL UNIQUE, is not supported, See :
>
>
http://msdn2.microsoft.com/en-us/library/ms714572.aspx

>
> PRIMARY KEY is not supported.
>
> You will have to add these constraints by typing them manually,
> before executing the script.
>
>You can also add these extra info, after you have created the table (executed script), directly to the table
>on your DBMS (database management system) using their control panel.
>
> Dave
>
>
> > Can this program also create
> > the relations between databases
> > (Foreign-Key contraints)?
> >
>

Follow Ups:

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> PRIMARY KEY is now supported since version 1.6.0.14. > > Known sources to provide Primary Key info is : MySql, MS SQL Server, and most Jet OLEDB supported Files (like Access). > If more than one key is found, and target SQL support only one Primary Key per table, Only first key found will be kept. > > Dave. > > > Udo, > > > > SQL Script Builder do not support datatable-relations or constraints, because it do not support any other statement than the column type. > > > > NOT NULL, NOT NULL UNIQUE, is not supported, See : > > > > <a href="http://msdn2.microsoft.com/en-us/library/ms714572.aspx"> > http://msdn2.microsoft.com/en-us/library/ms714572.aspx</a><br> > > > > PRIMARY KEY is not supported. > > > > You will have to add these constraints by typing them manually, > > before executing the script. > > > >You can also add these extra info, after you have created the table (executed script), directly to the table > >on your DBMS (database management system) using their control panel. > > > > Dave > > > > > > > Can this program also create > > > the relations between databases > > > (Foreign-Key contraints)? > > > > > > >

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]