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

8 votes279 views2 answers
Sqlsrv default port
SQL
0 vote268 views1 answer
Select even number id data from table
SQL
20 votes277 views5 answers
Sql show tables
SQL
13 votes264 views6 answers
Restart postgresql
SQL
3 votes276 views2 answers
How to delete git repo locally
SQL
0 vote303 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
5 votes250 views1 answer
Oracle asynchronous procedure
SQL
0 vote319 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote307 views1 answer
Sql select without column name
SQL
0 vote282 views1 answer
Order child below the parent in mysqli
SQL