<div>
also, if tables are temporary tables,<br />
<br />
you can execute query: DROP TABLE #delete_table_name<br />
<br />
<br />
suggestion: before you delete your tables, make sure have database back up just in case you mistake delete any table that you are not intended to.
</div>


also, if tables are temporary tables,

you can execute query: DROP TABLE #delete_table_name


suggestion: before you delete your tables, make sure have database back up just in case you mistake delete any table that you are not intended to.

<div>
Anoo<br />
<br />
I do not know SQL at all. &nbsp;How do you shrink a database?<br />
<br />
Thanks,<br />
CJA
</div>


Anoo

I do not know SQL at all.  How do you shrink a database?

Thanks,
CJA

<div>
Can anyone comment on how to shrink a databse in SQL 2005?<br />
<br />
Thanks,<br />
<br />
cja
</div>


Can anyone comment on how to shrink a databse in SQL 2005?

Thanks,

cja

<div>
<div class="content wysiwyg-content">
We are trying to reduce the space taken up by the database for our accounting system. &nbsp;We were told by their tech support which tables are temporary and can be deleted. &nbsp;How do I delete a table in SQL? Do I right click and choose &quot;delete&quot;?<br />
<br />
Also, I went into SQL, clicked on the database name and then on the tables folder but I did not see any tables that matched the names given to us by tech support. &nbsp;Any ideas on why they would not be there? &nbsp;Could SQl be deleting them automatically?<br />
<br />
Thanks,<br />
<br />
cja
</div>
</div>


We are trying to reduce the space taken up by the database for our accounting system.  We were told by their tech support which tables are temporary and can be deleted.  How do I delete a table in SQL? Do I right click and choose "delete"?

Also, I went into SQL, clicked on the database name and then on the tables folder but I did not see any tables that matched the names given to us by tech support.  Any ideas on why they would not be there?  Could SQl be deleting them automatically?

Thanks,

cja

Delete a table from SQL 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.