حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

How to set default value for an existing column in SQL Server database

band.atu...

Sir I have table in table IsActive column, I want to Set default value is zero or false how to set

ashusing...

0 3

hi @band.atul,

try this..

ALTER TABLE [dbo].[Customers_Transactions] ADD  CONSTRAINT [DF_Customers_Transactions_Debit]  DEFAULT ((0)) FOR [IsActive]

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

18.191.240.94