Dropping Tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Erin Peterson (dotnetcowboy_at_NOSPAM.hotmail.com)
Date: 03/01/04 

Date: Mon, 01 Mar 2004 20:01:41 GMT

Hi all.

Quick question about dropping tables.

If I drop a table do all of the associated indices and keys get dropped with
it as well or must they be separately and explicitly deleted?

SQL Server 2K

TIA,
Erin

Relevant Pages

  • Re: backup Keys
    ... "Back up the SQL Server 2005 encryption keys by using the corresponding SQL ... Regarding on the symmetric and asymmetric keys in SQL Server 2005 database, ...
    (microsoft.public.sqlserver.security)
  • Re: Why is this Not Updatable?
    ... have a Memo field. ... are there proper keys established on the SQL Server ... > warning that no changes can be made), do the primary key columns ...
    (microsoft.public.access.queries)
  • Re: why default index for primary key is clustered?
    ... >> So why SQL Server created clustered index by default for primary key ... When you had sequential tape files, ... A master tape would be read in sorted order ... Please post DDL, so that people do not have to guess what the keys, ...
    (microsoft.public.sqlserver.programming)
  • Re: Why is this Not Updatable?
    ... Bill To Info field instead of the BillToID field. ... are there proper keys established on the SQL Server ... > warning that no changes can be made), do the primary key columns ...
    (microsoft.public.access.queries)
  • Re: "pivoting" when the column selectors are inequalities?
    ... Please post DDL, so that people do not have to guess what the keys, ... CREATE TABLE Foobar ... But not in SQL Server: ...
    (microsoft.public.sqlserver.programming)