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?
tnt
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
|||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