Add new column after in sql

T-SQL Add Column

ALTER TABLE sales.quotations 
    ADD 
        amount DECIMAL (10, 2) NOT NULL,
        customer_name VARCHAR (50) NOT NULL;
Code language: SQL (Structured Query Language) (sql)

Source: sqlservertutorial.net

Add new column after in sql

ALTER TABLE `fb_banners`
ADD `city_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER `BannerID`,
ADD INDEX `Foreign_city_id_banners` (`city_id`) USING BTREE,
ADD CONSTRAINT `Foreign_city_id_banners` FOREIGN KEY (`city_id`) REFERENCES `foodsafari`.`fb_cities` (`id`) ON UPDATE CASCADE ON DELETE CASCADE;

Similar codes

3 votes150 views2 answers
How to start postgresql on windows
SQL
1 vote159 views1 answer
How to get previous year from sysdate in oracle
SQL
2 votes189 views1 answer
Username sql
SQL
3 votes149 views2 answers
Df to sql pandas sql achemy
SQL
1 vote145 views1 answer
Oracle convert run duration to number
SQL
19 votes147 views6 answers
Sql server drop table if exists
SQL
0 vote143 views1 answer
Désinstaller postgresql linux
SQL
6 votes100 views2 answers
Spring data jpa application.properties mysql
SQL
1 vote139 views1 answer
Sql headers delphi
SQL
0 vote153 views1 answer
Select year from dual oracle
SQL