https://www.webmaster-forums.net/crss/node/1012843 en https://www.webmaster-forums.net/web-database-development/how-do-i-get-database#comment-1074400 <p>Ravi,</p> <p>You didn't say if you wanted to keep the data or not. If you simply want to delete it just make an ASP page and use the DROP TABLE [tablename] command. This will remove the table.</p> <p>If you want to keep the data then you'll have to export it to another database. You could upload an empty Access database that has all the same table &amp; field names and then create an ASP page that selects the data from the SQL database and then inserts it into the access database, you could then download the Access database.</p> <p>The simplest way would be to use Enterprise Manager and use the built in tools and wizards rather than creating ASP pages. If you don't have it then go to Microsoft's SQL site (<a href="http://www.microsoft.com/sql" title="www.microsoft.com/sql">www.microsoft.com/sql</a>) and order the evaluation version which is only $9.95) this comes with Enterprise Manager. You don't have to install SQL server, just select Desktop installation and then select connectivity tools.</p> Tue, 21 Nov 2000 18:40:31 +0000 Peter J. Boettcher comment 1074400 at https://www.webmaster-forums.net