Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alter table statement with multiple constraints?

Status
Not open for further replies.
jisoo23

jisoo23

Programmer
Jan 27, 2004
192
0
0
US
Hello all,

Does anyone know if ther alter table statement can handle multiple constraints like create table does? By that I mean a primary key declaration and 1 or more foreign key declarations?

Thanks,
Jisoo23
 
Sort by date Sort by votes
no, you should do as many alter tables as changes you need
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

wbower34
  • Locked
  • Question
Issues with table join
Replies
2
Views
73
wbower34
wbower34
wbower34
  • Locked
  • Question
sum hours fields into another table
Replies
0
Views
62
wbower34
wbower34
harfri
  • Locked
  • Question
Who can help me with a report in SQL
Replies
1
Views
66
feherke
feherke
dbuxton101
  • Locked
  • Question
Simple way of Exporting and Importing a Table
Replies
0
Views
73
dbuxton101
dbuxton101
MrCBofBCinTX
  • Locked
  • Question
Trigger/Function Update 1st table when update 2nd table?
Replies
2
Views
64
MrCBofBCinTX
MrCBofBCinTX

Part and Inventory Search

Sponsor

Back
Top