Visit to NFM Head Office with Mr. Andrew John Approved by Imran Ijaz
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);
Comments
Post a Comment