Home sql-server Deleting column from table

Deleting column from table

Author

Date

Category

How to remove column from the SQL Server table?


Answer 1, Authority 100%

alter table table_name drop column_name
Does not roll? …

Not enough words “column”, the query should look like this:

alter table 'table_name' drop column 'column_name'

Answer 2, AUTHORITY 77%

alter table `table_name` Drop Column` COLUMN_NAME`

does not roll? …

UPD: Recovery Call about the keyword column


Answer 3, Authority 31%

mysql_query ("alter table_Table Drop Column name_stolbets");

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions