My first post here.
I am creating a stored procedure which duplicates a an existing table, and feeds data to its first column only. It turns out that the source table does not allow null values. This latter part is causing problems because whereas it accepts the full syntax:
ALTER TABLE [db].[table1] ALTER COLUMN [column1] NVARCHAR(42) NULL
the following : ALTER TABLE [db].[table1] ALTER COLUMN [column1] NULL
is returning a syntax error.
What would be the most elegant way to make columns null-enabled without changing their other parameters?