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 strongm 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
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
140
wbower34
wbower34
wbower34
  • Locked
  • Question
sum hours fields into another table
Replies
0
Views
121
wbower34
wbower34
harfri
  • Locked
  • Question
Who can help me with a report in SQL
Replies
1
Views
132
feherke
feherke
dbuxton101
  • Locked
  • Question
Simple way of Exporting and Importing a Table
Replies
0
Views
131
dbuxton101
dbuxton101
MrCBofBCinTX
  • Locked
  • Question
Trigger/Function Update 1st table when update 2nd table?
Replies
2
Views
98
MrCBofBCinTX
MrCBofBCinTX

Part and Inventory Search

Sponsor

Back
Top