Can not change table's structure
Can not change table's structure
(OP)
Hi everybody,
I'm trying to change the table to have the ID field as GUID (it was int Identity field). However, then I try to save it I'm getting an error preventing me saving changes. I also see a table with the same name and _tombstone prefix (two fields - ID and DeletionDate).
What should I do to be able to change the table structure?
I already truncated this table.
Thanks in advance.
I'm trying to change the table to have the ID field as GUID (it was int Identity field). However, then I try to save it I'm getting an error preventing me saving changes. I also see a table with the same name and _tombstone prefix (two fields - ID and DeletionDate).
What should I do to be able to change the table structure?
I already truncated this table.
Thanks in advance.
RE: Can not change table's structure
2. Change the column's definition to GUID (be sure to add a default if needed)
3. Rename the old table
4. Run the SQL script to create the new table.
5. Copy the data from the old table into the new table.
6. Once you are satisfied with the results, drop the old table.
RE: Can not change table's structure
RE: Can not change table's structure
RE: Can not change table's structure
But now I already re-created my table, just didn't specify the PK. Now I want to specify the ID field as a PK in the designer and again it doesn't let me :(((
The table has triggers, so I would have to do everything through the scripts again?
RE: Can not change table's structure
CODE
RE: Can not change table's structure
Looks like some internal SSMS bug to me in SQL Server 2008 Express.
RE: Can not change table's structure
Anyway, thanks a lot again.
RE: Can not change table's structure