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
How to find max and min salary in sql
SQL
2 votes178 views1 answer
Sql find not in list
SQL
9 votes193 views6 answers
Oracle substring
SQL
2 votes165 views2 answers
Mysql limit
SQL
3 votes171 views2 answers
Sqlite print all column names
SQL
0 vote174 views1 answer
Mysql changer nom table
SQL
0 vote190 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote173 views2 answers
Plsql function that return a table
SQL
2 votes166 views1 answer
Oracle find unusable indexes
SQL
1 vote161 views1 answer
Postgres get timestamp
SQL