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 votes180 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote206 views1 answer
Mysql export data with a where clause
SQL
10 votes190 views2 answers
Show tables in schema oracle
SQL
1 vote314 views1 answer
Postgres set column based on another column
SQL
8 votes211 views1 answer
Ltrim sql
SQL
7 votes260 views2 answers
Oracle foreign key reference table
SQL
0 vote168 views1 answer
Excute raw query
SQL
0 vote200 views1 answer
Postgresql port 5432 not open
SQL
0 vote200 views1 answer
Sql select min row
SQL
5 votes183 views3 answers
Sql make column nullable
SQL