Removing a table from a database

Guys,
I have a few tables that I want to remove. Any thing I have to be concern
about?
tntYou can check the dependencies to make sure there are no objects that depend
on the tables. Not perfect but in most cases will do a good job. Then
performing a backup before dropping the tables, just in case you need them
back.
HTH,
Plamen Ratchev
http://www.SQLStudio.com|||How do I do that- checking the dependecies. I was looking at the database
relationship manually.
tnt
"Plamen Ratchev" wrote:
> You can check the dependencies to make sure there are no objects that depend
> on the tables. Not perfect but in most cases will do a good job. Then
> performing a backup before dropping the tables, just in case you need them
> back.
> HTH,
> Plamen Ratchev
> http://www.SQLStudio.com
>|||SQL Server 2005 - In SQL Server Management Studio right click on the table
name and select View Dependencies
SQL Server 2000 - In Enterprise Manager right click on the table name and
select All Tasks -> Display Dependencies
HTH,
Plamen Ratchev
http://www.SQLStudio.com