Snitz Forums 2000 - Altering Constraints...

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: Database: MS SQL Server

Altering Constraints...

New Topic

Topic Locked

Printer Friendly

Author

Topic

SiSL
Average Member

Turkey
671 Posts

Posted - 16 February 2009 : 15:38:00

Greetings,

I have two databases of SQL2008... And two same tables in each... Ofcourse one of them is not created automatically, so missing contraints or only one primarykey instead of 3... (Data, however, is different)

So how can I copy one of tables constraints and pk options etc. without damaging existing data?
<

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 February 2009 : 17:06:07

Script the table using EM and then use the statements to create ALTER TABLE statements for the existing table.<

Snitz 3.4 Readme | Like the support? Support Snitz too

SiSL
Average Member

Turkey
671 Posts

Posted - 17 February 2009 : 03:55:42

Well problem is here ruirib, I don't see Script to-> "Alter to" highlighted, it is disabled when I used it on table :(
<

Edited by - SiSL on 17 February 2009 03:55:57

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 17 February 2009 : 04:09:32

just right click on the constraint you want to copy from and script constraint as 'create to'

then just change the table names etc and then run the create constraint queery<

SiSL
Average Member

Turkey
671 Posts

Posted - 17 February 2009 : 13:47:29

Ah great, thanks :)<

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.18 seconds.