Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pazzy11
Posting Yak Master
145 Posts |
 Posted - 2007-11-13 : 11:48:45
|
| What is the ALTER statement for ?for example in some stored procedures you have ALTER PROCEDURE (procedure name..) |
|
|
jhocutt
Constraint Violating Yak Guru
385 Posts |
Posted - 2007-11-13 : 11:53:57
|
| The statement is used to alter a table/Procedure/function/etc See BOL for a complete definition"God does not play dice" -- Albert Einstein"Not only does God play dice, but he sometimes throws them where they cannot be seen." -- Stephen Hawking |
 |
|
|
pazzy11
Posting Yak Master
145 Posts |
Posted - 2007-11-13 : 11:54:27
|
| BOL wasn't much help... |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-13 : 12:09:28
|
quote:
Originally posted by pazzy11
BOL wasn't much help...
Read about ALTER PROCEDURE in BOLMadhivananFailing to plan is Planning to fail |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-13 : 13:51:44
|
On a high level the ALTER statement does exactly what it sounds like it does. CREATE allows you to create objects, ALTER allows you to alter objects, if it reads ALTER PROCEDURE then it is issuing a change to the procedure. CREATE, ALTER, DROP, TRUNCATE are all Data definition language statements.
Future guru in the making. |
|
|
|
|
|
|
ALTER ?