Create an empty table from an existing table keeping the default value constraint

0 votes

1 answer

269 views

I tried:

Select * Into  From  Where 1 = 2

but the default value constraint is not created. I have a smalldatetime column whose default value is getdate().

Asked by Rick (115 rep)

Aug 12, 2021, 11:37 AM
Last activity: Aug 17, 2021, 09:54 AM