Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

sql alter table query

Name: mark
Date: March 19, 2003 at 08:06:23 Pacific
OS: w2k
CPU/Ram: p4 512mb

Comment:

easy one if this works alter table sheet1 drop column field1 ; why does this not Alter table sheet1 drop column field1, drop column field2 ; 2nd drop column says error. cant sus it, cheers for any help

Name: gpp
Date: March 19, 2003 at 08:08:27 Pacific

Reply:

If your trying to show us some code, it didnt post.

0

Name: mark
Date: March 19, 2003 at 08:18:26 Pacific

Reply:

that is the code, its a sql query to remove various columns from a table

0

Name: gpp
Date: March 19, 2003 at 09:23:10 Pacific

Reply:

Sorry, the spacing threw me off. This code should work... alter table TABLE_NAME DROP column ONE, DROP column TWO, DROP column THREE; of course this wont work if your dropping all columns in the table.. to do that, you have to use DROP TABLE. In other words, there must be at least one column left over.

0

.net : data grid ??

VB 6.0 and sql

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: If you want to add a field to the database table? You need to use an ADODB.Connection object and the SQL command ALTER TABLE Like this: Dim ConnString ' Connection String Dim CN As ADODB.Connection Se...

Summary: I have a SQL Server Table that has a column with a number in it. Is there a way that I can query that table to find out what the number is and create that number of rows in a new table. ...

Summary: Hi all. I got a proble with SQL query I want to use. I got the following 2 Tables. SKU and SKUXLOC Example. SKU TABLE SKU |Description |Supp ----------------------- 1234 |Book1 |Supp1 4567 |B...