Viewing 3 posts - 1 through 3 (of 3 total)
Hi
could you tell the structure of the table and the name of the column wich you are trying to delete .Maybe it is some reserved word
Lata
December 3, 2001 at 8:30 pm
#420660
You can do a roundabout way by setting the Result Options in the query Analyser to File and using the for xml explicit option to specify the output...
December 3, 2001 at 5:47 am
#420612
To delete a column you give
Alter table table1 drop column colname
However if you have any constraint on the column like primary key or any other computation ,based on...
December 3, 2001 at 4:44 am
#420607