delete column in database

[srinath@elsys.in]

Hi All,

Ca anybody Explain me how to delete the perticular entire column  in a table.

Regards,

Srinath 

[Prabhakant_Patil]

I think you can not delete a complete coulmn from the table in the database.

either you have to create new table in the database.

or else you can delete values from the selected cloumn by writing delete query. (

DELETE FROM table_name
WHERE some_column=some_value)

[Prabhakant_Patil]

Just note for you

WHERE clause in the DELETE syntax. The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!

[Prabhakant_Patil]

It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact

Use following query

DELETE FROM table_name

or

DELETE * FROM table_name

[Dennis_Knutson]

Did you even try a google search for deleting a column with SQL? Of course not, otherwise you would not be asking the question, I guess. Why you think this is a LabVIEW question, I have no idea, though. Look up the ALTER TABLE syntax.

[Prabhakant_Patil]

Correct.

Just Check with the SQL Help

[PhillipBrooks]

Do you want to delete a column, or change the value of a field (column name) of all records to nothing (NULL).

If you want to clear/change to NULL then you can use an UPDATE statement, but this is not something that you 'just play around with'

Spoiler

UPDATE table_name SET column_name = NULL

[Prabhakant_Patil]

Example of Update statement is

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value

[srinath@elsys.in]

Hi Patil,

Can you Explainme how to rename the Column name in a table

Regards,

srianth

[Prabhakant_Patil]

You can use foolwing statement to rename column name

sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

More in details

USE [Database name]

GO
sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

GO