Add column mssql

Create column sql server

ALTER TABLE table_name
ADD column_name datatype;

Alter table add column

ALTER TABLE table_name 
ADD column_name datatype;

Add column 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;

Add column mssql

ALTER TABLE Customers
ADD Email varchar(255);

Similar codes

2 votes113 views1 answer
How to add where command in update comand with joins
SQL
0 vote119 views1 answer
Sql requete number pair
SQL
0 vote106 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
1 vote126 views1 answer
Show structure of table in sql
SQL
0 vote116 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote121 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote154 views1 answer
Update sql sintax
SQL
1 vote119 views1 answer
Oracle difference between two dates in years
SQL
0 vote119 views1 answer
Pl sql disable trigger
SQL
0 vote136 views1 answer
Sql query inline if
SQL