SQL SERVER TABLE CREATE NEW FIELD UPDATE, DELETE - fabulouscode

Sunday, September 1, 2019

SQL SERVER TABLE CREATE NEW FIELD UPDATE, DELETE


Create Table ::
CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255
);


Field Update Structure::
ALTER TABLE table_name

ADD column_name datatype;

EXAMPLE::
ALTER TABLE tblUnitList
ADD KORMEE_UNITID int;

No comments:

Post a Comment

I am Safiqul Islam Tuhin