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

0 vote187 views1 answer
Download mysql database to excel in android studio
SQL
0 vote183 views1 answer
Disableforiegn key check
SQL
1 vote180 views1 answer
Mysql order by desc null last
SQL
5 votes206 views1 answer
Oracle nls session
SQL
1 vote184 views2 answers
Populate sql table with random data
SQL
0 vote202 views1 answer
Insert array into mysql column
SQL
0 vote204 views1 answer
Object of class mysqli_result could not be converted to string
SQL
12 votes192 views4 answers
Psql command not found
SQL
0 vote193 views1 answer
Drop unique
SQL
7 votes195 views6 answers
Group_concat mysql
SQL