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

0 vote167 views2 answers
Postgresql create role
SQL
3 votes177 views2 answers
Current year sql
SQL
0 vote181 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote196 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote146 views1 answer
Query for maximum salary
SQL
1 vote191 views2 answers
Mysql error 1215
SQL
0 vote193 views1 answer
SQL Cut part string
SQL
0 vote194 views1 answer
Typeorm raw sql
SQL
1 vote206 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
1 vote171 views1 answer
Oracle convert run duration to number
SQL