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);
Everyone wants to read the quality content. Your article is informative and full the quality content. I would like to read more on the maintenance services. Thank you for the useful blog
ReplyDelete