SQL SERVER 2005 Express Create Table Relationship

  • Thread starter Thread starter JP Bless
  • Start date Start date
J

JP Bless

I am trying to create table relationships in SQL server 2005 Express with
out success. I am using Microsoft Management Sudio Express. The problem is I
can see the toolbar that points to relationship, Query, Table creation but
they are all greyed out. The tables I have were created by Access upsizing
wizard. Before starting the upsizing wizard I deleted all relationships
created in MS Access. Now I need to create the relationship in the SQL
Server 2005 Express database. How do I do this... Thanks in advance.
 
After "upsizing", you need to re-examine your tables' structure before rush
into creating relationships. After all, Jet database is quite different from
SQL Server database. It is very likely (when upsizing from Access) and
common that the tables' PK is gone, (thus the toolbar is greyed out), so you
need to reset PKs for the tables before you can create relationships. You
may also want to examine colums' data type. For example, Jet DB's memo type
would be converted into ntext, while nvarchar/varchar may be more suitable
in SQL Server.
 
Thanks Norman... I appreciate your response
Excuse my newbie syndrome... how do I rest table PK? And what is PK? My
first time playing with (actually learning/using) SQL Express server 2005
Express.
 
Figured PK... means primary key. I have figured how to modify all the
tables... then set the table primary key... I am getting there. Thanks
Norman.
 
Back
Top