Answers for "add a column in sql"

SQL
7

append column sql

ALTER TABLE table_name
ADD column_name datatype;

--example
ALTER TABLE Customers
ADD Email varchar(255);
Posted by: Guest on May-11-2020
12

alter table add column

ALTER TABLE table_name
ADD column_name datatype;
Posted by: Guest on March-15-2020
15

sqlserver add column to table

ALTER TABLE dbo.doc_exa 
ADD column_b VARCHAR(20) NULL, 
	column_c INT NULL ;
Posted by: Guest on April-08-2020
13

alter table add column

ALTER TABLE table
ADD COLUMN column VARCHAR (255) NOT NULL AFTER column;
Posted by: Guest on April-08-2020
9

alter table add column

ALTER TABLE table_name 
ADD column_name datatype;
Posted by: Guest on July-08-2020
0

T-SQL Add Column

ALTER TABLE sales.quotations 
    ADD 
        amount DECIMAL (10, 2) NOT NULL,
        customer_name VARCHAR (50) NOT NULL;
Code language: SQL (Structured Query Language) (sql)
Posted by: Guest on August-10-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language