Software and Web Development

Following is the important script for database server as the table "tbl_Log" as already created. For Adding Default Value in Table ALTER TABLE YourTable ADD CONSTRAINT DF_SomeName DEFAULT N'1' FOR YourColumn ; For Increasing the Column Size ALTER TABLE YourTable ALTER COLUMN YourColumn VARCHAR (50) NOT NULL; For Add/Creating New Column ALTER TABLE PRESENTED_VOUCHER add  descrip  nvarchar(200); For Change/Modify Existing Column  ALTER TABLE PRESENTED_VOUCHER alter column  descrip  nvarchar(200);