Link to home
Create AccountLog in
Avatar of cja-tech-guy
cja-tech-guyFlag for United States of America

asked on

Delete a table from SQL 2005

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
ASKER CERTIFIED SOLUTION
Avatar of pdd1lan
pdd1lan

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of pdd1lan
pdd1lan

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.
SOLUTION
Avatar of Anoo S Pillai
Anoo S Pillai
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of cja-tech-guy

ASKER

Anoo

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

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

Thanks,

cja