Delete a field in SQL Server 6.5 
Author Message
 Delete a field in SQL Server 6.5

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



Tue, 10 Aug 2004 12:42:38 GMT  
 Delete a field in SQL Server 6.5
I'm afraid you have to create a new table, copy over the data, then delete
the old table and rename the new.

Janne


Quote:

> 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



Tue, 10 Aug 2004 19:48:07 GMT  
 Delete a field in SQL Server 6.5

Quote:

>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 don't check it very often.



Tue, 10 Aug 2004 20:13:19 GMT  
 Delete a field in SQL Server 6.5
Hi,

ALTER TABLE allows to modify structure of table. Check
full syntax in BOL

Val

Quote:
>-----Original Message-----

>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

>.



Tue, 10 Aug 2004 21:03:08 GMT  
 Delete a field in SQL Server 6.5
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.


Quote:

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

don't check it very often.


Fri, 13 Aug 2004 06:28:11 GMT  
 Delete a field in SQL Server 6.5

Quote:

>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.



Fri, 13 Aug 2004 07:18:29 GMT  
 Delete a field in SQL Server 6.5
Bob,
My apologies back to you Bob. Monday morning, bad weekend and a pile of
end-user problems to greet me this morning.
Thanks for your assistance.
KB


Quote:

> >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.



Fri, 13 Aug 2004 07:37:28 GMT  
 Delete a field in SQL Server 6.5
Not in 6.5 it doesn't. Check Bob Barrows second reply to me.


Quote:
> Hi,

> ALTER TABLE allows to modify structure of table. Check
> full syntax in BOL

> Val

> >-----Original Message-----

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

> >.



Fri, 13 Aug 2004 07:43:18 GMT  
 Delete a field in SQL Server 6.5
Hello,

Following is simple sample of T-SQL about how to delete a column:

ALTER TABLE <TableName> DROP COLUMN <ColumnName>

 Alter a table to drop a column
This example modifies a table to remove a column.

CREATE TABLE doc_exb ( column_a INT, column_b VARCHAR(20) NULL)

GO

ALTER TABLE doc_exb DROP COLUMN column_b

GO

EXEC sp_help doc_exb

GO

DROP TABLE doc_exb

GO

Hope it helps!

Regards,
Allan Sun
This posting is provided "AS IS", and confers to no rights.



Sat, 14 Aug 2004 11:05:22 GMT  
 
 [ 9 post ] 

 Relevant Pages 

1. Delete a field in SQL Server 6.5

2. Project: Retrieving text fields from SQL Server 6.5

3. Loading Rich Text Box from SQL Server 6.5 Text Field

4. image fields in SQL Server 6.5, how to..?

5. New Transact-SQL Debugger for Microsoft SQL Server 6.5/7.0

6. Import text file in SQL Server 6.5 via SQL in Visual Basic

7. SQL Debugger for Microsoft SQL Server 7.0 and 6.5

8. Import text file in SQL Server 6.5 via SQL in Visual Basic

9. ERwin 2.5 Cascading Deletes/Updates with MS SQL 6.5

10. Text/Memo Fields in SQL 6.5

11. ADO / SQL 6.5 / Text Fields

12. Image Fields - VB6, SQL 6.5

 

 
Powered by phpBB® Forum Software