SQL Recipes
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers

Reply
 
LinkBack Thread Tools Search this Thread
  #1 (permalink)  
Old 02-05-2008, 12:15 PM
Saisri Dash Saisri Dash is offline
Junior Member
 
Join Date: Feb 2008
Posts: 2
Saisri Dash is on a distinguished road
Question ANY dialect question:

dropping a column from table


Hi,
Please anyone can help me.
I want to drop column from a table.I am using
ALTER TABLE Employees DROP FirstName;
The error its showing is

'FirstName' is not a constraint.
Could not drop constraint. See previous errors.

How to solve it?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

ANSWER(S):

  #2 (permalink)  
Old 02-05-2008, 11:07 PM
Dimitar
 
Posts: n/a
Default ANY answer. Re: dropping a column from table

Hi,
You could try this:
Code:
alter table t drop column c1
SQL1992 specifies the 'column' keyword is optional, but since it does not work this way in the database engine you are using, you could try and specify it (the keyword) explictly.

Hope this helps,
Dimitar
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-06-2008, 10:28 AM
Saisri Dash Saisri Dash is offline
Junior Member
 
Join Date: Feb 2008
Posts: 2
Saisri Dash is on a distinguished road
Smile ANY answer. Re: dropping a column from table

Thanks a lot.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 03:46 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8