Rename a NOT NULL column with no default in a SQL Server 2000 table in Merge Replication
Using sp_repladdcolumn
I can either:
Without dropping and recreating the whole subscription I would like to:
3) add a column with no default value that does not allow nulls.Is this possible?
I realize I would need to populate the column with data before I could set it to NOT NULL. As the title indicates, what I really want to do is rename an e开发者_StackOverflow社区xisting column that: a) has data in it, b) is set to NOT NULL, and c) has no default value.To just rename a column, why not just use sp_rename?
精彩评论