How to delete an existing table in SQL Server Database

pp1234

SOLVED CLOSED ACTIVE ANSWERED
User: pp1234
Posted: on Nov 21, 2013 01:36 AM
Forum: SQL Server
Answer: 1
Views: 2328

i have created a new table into database with excel column headers as columns,wile i upload a new excel sheet.for this i refer this one

http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx

now in this program,i want to delete the existing table automatically while i ceateing the new one,and uploading the new excel,how it is possible,can you please tell me

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Nov 21, 2013 01:37 AM
Report

Write a query yo Delete the table and excute it before executing the stored procedure

Drop Table MyTable

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to delete an existing table in SQL Server Database

Company

Explore

Follow us

Contact Us