Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to delete columns in sql

ALTER TABLE tableName
DROP COLUMN columnName;
Comment

sql delete column

Deletes a column from a table.
Example: Removes the first_name column from the users table.
ALTER TABLE users
DROP COLUMN first_name
Comment

PREVIOUS NEXT
Code Example
Sql :: ORACLE RIGHT TWO DIGITS 
Sql :: mysql left join exists 
Sql :: count mysql server db tables 
Sql :: postgres delete last row 
Sql :: sql server reset auto increment 
Sql :: having count greater than 1 mysql 
Sql :: select item.* as json mysql 
Sql :: sqlite3 how to get column names of a table 
Sql :: set statiscis on in ssms 
Sql :: invalid reference to FROM-clause entry for table "unidades 
Sql :: get the rows from two tables whose relation is in 3rd table 
Sql :: how to copy data of a table from another database to table of anaother database 
Sql :: change default maximum runtime mariadb from phpmyadmin 
Sql :: sql server utc to local 
Sql :: get the mysql table columns data type mysql 
Sql :: set boolean flasksql 
Sql :: edate dax 
Sql :: mysql month name extract 
Sql :: get rows affected mysql python 
Sql :: SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1 
Sql :: how to get the ddl for datafile in oracle tablespace 
Sql :: helptext in sql 
Sql :: get all table names in sql 
Sql :: update set with inner join oracle 
Sql :: how to find the most occuring in SQL 
Sql :: select tables with name like mysql 
Sql :: describe table query in postgresql 
Sql :: oracle ora-00054 find 
Sql :: oracle grant select on schema 
Sql :: create a unqie constraint mysql 
ADD CONTENT
Topic
Content
Source link
Name
9+1 =