Horje
add column in sql Code Example
append column sql 
ALTER TABLE table_name
ADD column_name datatype;

--example
ALTER TABLE Customers
ADD Email varchar(255);
sql server alter column 
ALTER TABLE table_name 
ALTER COLUMN column_name new_data_type(size);
Source: www.sqlservertutorial.net
sqlserver add column to table 
ALTER TABLE dbo.doc_exa 
ADD column_b VARCHAR(20) NULL, 
	column_c INT NULL ;
alter table add column 
ALTER TABLE table
ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;
create column sql server 
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;



Sql

Related
consecutive numbers sql Code Example consecutive numbers sql Code Example
sql inner join Code Example sql inner join Code Example
Create table Statement Syntax in SQL Server Code Example Create table Statement Syntax in SQL Server Code Example
opera gx Code Example opera gx Code Example
odd record sql query Code Example odd record sql query Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje