Drop Table command giving error in SQL
When I am using DROPTABLE & TABLE_NAME command in SQL, its showing some error. What can be the problem
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
AartiPosted Nov 15, 2011, 8:31 AM
your query for drop table here
DROPTABLE & TABLE_NAME
this should be like DROP TABLE TABLE_NAME there should be space b/w DROP AND TABLE keyword. as i see
plz post exact error message or query......
Thanks.
Santosh KumarPosted Nov 7, 2011, 11:51 AM
Bhavik SolankiPosted Nov 7, 2011, 8:51 AM
Here is query for drop table. Drop table [TableName1]
You can drop multiple tables using this Drop table [TableName1],[TableName2]
Regards,
Bhavik
Prabhu RajaPosted Nov 7, 2011, 5:28 AM
Mention your Error Message and try this Article:
http://www.c-sharpcorner.com/UploadFile/mahesh/CreatingDBProgrammaticallyMCB11282005064852AM/CreatingDBProgrammaticallyMCB.aspx
Pravin MorePosted Nov 6, 2011, 11:50 PM
you have not posted exact error message or query......
please give somthing to resolve it.
but i hope your query will be......... drop table table_name