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

5 votes351 views1 answer
Mysql change primary key
SQL
0 vote389 views1 answer
Csv to sqlite python
SQL
1 vote370 views1 answer
How to subtract from the value of a table in sql
SQL
31 votes359 views4 answers
How to get duplicate records with multiple field in sql
SQL
8 votes356 views1 answer
Oracle search source code
SQL
0 vote354 views1 answer
Php delete database
SQL
0 vote365 views1 answer
Why we have to set the password for my sql server
SQL
0 vote349 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
25 votes372 views1 answer
Mysql grant all privileges to a user
SQL
8 votes347 views1 answer
Mysql restore database
SQL