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 |
|
kashyapsid
Yak Posting Veteran
78 Posts |
 Posted - 2010-05-11 : 03:01:22
|
| IF OBJECT_ID('dbo.Orders', 'U') IS NOT NULL DROP TABLE dbo.Orders;i want to known wt this query does please cooperateKaShYaP |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-11 : 03:11:11
|
If table dbo.Orders exists then it is dropping this table.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
kashyapsid
Yak Posting Veteran
78 Posts |
Posted - 2010-05-11 : 03:15:10
|
| that means after the execution of the query the table will be deleted rightKaShYaP |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-11 : 03:19:33
|
Yes if exists.In most cases this statement comes first and then comes a create table statement to make that table new and actual and empty.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
kashyapsid
Yak Posting Veteran
78 Posts |
Posted - 2010-05-11 : 03:21:43
|
| that is the reason i am losing the data in the table tnks for your consideringKaShYaP |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-11 : 03:23:14
|
welcome 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
statement