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

Status
Not open for further replies.
zgrande

zgrande

Programmer
Mar 18, 2002
15
BR
When an ALTER TABLE command adding a column with default value is executed, an UPDATE command will populate the new column with the default value, right? So, if there´s an "on" update trigger on this table, will this trigger be executed too?
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
377
carp
carp
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
317
Livia8
Livia8
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
395
carp
carp
Andrzejek
  • Locked
  • Question
Copy a table from Test to Production
Replies
1
Views
101
carp
carp
DeShaun
  • Locked
  • Question
Mutiple Where table in Update/Set
Replies
10
Views
145
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top