07-13-2012 09:44 AM
That is a stored procedure and is not much good without actually explaining what a stored procedure is, how to use one, and how to check if your db has that specific one. Better to answer with the SQL command.
STOP posting SQL questions here. They are not at all LabVIEW related.
07-13-2012 05:23 PM
@Dennis_Knutson wrote:
STOP posting SQL questions here. They are not at all LabVIEW related.
Unless the original poster was asking how to do this with LabVIEW. That was my assumption anyway.
Srinath, are you using the Database Connectivity Toolkit, LabSQL or something similar? If you are not trying to do this with LabVIEW then as Dennis said, you are in the wrong place.
I don't have any of these toolkits installed but I have briefly used the two I mentioned a while back. I don't remember there being a VI that will delete a column. By delete column I understand it to mean that you want to remove the column from the table and not just clear all values in the column. Big difference!
The Database Connectivity Toolkit does have a VI to execute an SQL query. You have to look it up for your database but deleting a column is probably something like ALTER TABLE tablename DROP COLUMN columnname.