> How the hell do you delete a field from an existing table in SQL Server
6.5?
> I don't care how (TSQL, DAO, ADO, Enterprise Manager), I just want to get
> rid of the fields that I don't use.

> KB

>How the hell do you delete a field from an existing table in SQL Server 6.5?
>I don't care how (TSQL, DAO, ADO, Enterprise Manager), I just want to get
>rid of the fields that I don't use.

>KB

> >How the hell do you delete a field from an existing table in SQL Server
6.5?
> >I don't care how (TSQL, DAO, ADO, Enterprise Manager), I just want to get
> >rid of the fields that I don't use.

> >KB

> Don't you have Books Online (BOL)? They should have been installed
> when you installed SQL Server. Just look in the SQL Server program
> group.

> If you can't find the answer to this question in BOL, then you need a
> lot of help with your research skills. :-)

> HTH,
> Bob Barrows
> Please reply to the newsgroup. My reply-to address is my "spam trap" and I

> >Ok Bob, you tell me where it mentions in BOL that a field can't be
deleted
> >in 6.5. And then, you tell me whether or not the microsoft newsgroups are
a
> >valid source of research.

> Whoa - you seem to think I was insulting you or somthing. Sorry if
> that was the impression I gave. I thought I was telling you how to
> find your answers quicker than posting questions in a newsgroup and
> waiting for someone to answer them. Hmm, I just reread my message, and
> I can see that apologies are definitely in order. I can see why you
> would take offense (I must have been in a bad mood when I wrote that).

> Anyways, regarding your challenge:

> I opened BOL (6.5), clicked the Find button in the toolbar, and
> entered "delete column". Clicking OK resulted in a dialog listing
> quite a few hits. The first hit, "System messages", did not seem
> relevant, so I selected the second hit (ALTER TABLE statement).
> Halfway down the page I found this quote at the beginning of the
> Remarks section:

> ALTER TABLE adds columns or constraints to a table, or drops
> constraints from a table, but it does not allow columns to be removed.

> OK, so this topic does not seem to go into any detail in on how to
> remove a column. But I could swear I learned how to remove columns
> from BOL. Hmm - can't seem to find it now ... hmm, you seem to be
> right: no mention of how to drop a column (which should be a good
> indication that there is no way to do it short of creating a new
> table,etc. - but you're right: that seems to be a rather large leap
> for a newcomer to make). In my defense, It's been at least a year
> since I even opened 6.5's BOL. In 7.0, they added a DROP COLUMN
> statement

> Sorry,
> Bob Barrows

> PS. While the newsgroups are a valid source of research, they should
> be utilized on a last-resort basis. In no way should they be
> considered a substitute for reading the manual.