Trying to learn about SMO within SQL, went trough some issues when found the Imported data needed some Primary Key, so decided to create another table this one with the primary Key autogenerated then just populate data with:
CREATE TABLE New_Table
(
ID int NOT NULL IDENTITY(1,1) PRIMARY KEY,
Category varchar(255),...
....blah blah blah more columns....
)
Then to populate the data:
INSERT INTO New_Table
SELECT * FROM Original_Table
And voala we have a new table with the Auto Generated Primary Key. But the problem since I created the smart objects and also some views, when I realized did not have the indexes, went to SQL and Delete the original tables.
No I ended with Orphaned Categories that can't be deleted.
Then when right click and try to delete...
I wonder if there is a way to run a SQL Query to clear the orphanned Items within the Database to prevent this issues... or something within designer that allow overwrite the deletion because the object no longer exists.
THX Dino.
