Re: Relations / ForeignKeys

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

Posted by Dave on March 10 2005 20:52:36:

In Reply to: Relations / ForeignKeys posted by Udo Schneider on March 10 2005 11:38:57:

Udo,

SQL Script Builder do not support datatable-relations or constraints, because it do not support any other statement than the column type.

Other things it can not support :

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 simply 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:

Re: Relations / ForeignKeys - Primay Key Now supported - Dave 22:15:49 June 27 2007 (1)
- Re: Relations / ForeignKeys - Primay Key Now supported - Sudhanshu Sinha 02:58:40 September 18 2007 (0)

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> 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 ]