Table Split

• 
  Since it seems to be tricky to find the "Split Table" feature, here is how you can get to it:
  
  Make sure the "Object Explorer" is visible (press F8, or View->Object Explorer).
  
  expand the database objects, and find a table you would like to split. Right click on it, and this will bring up a context menu. In this menu there will be an entry with a red icon (the only one with an icon), and this will invoke the table split.
  
  Regards,
  Andras

  Andras B August 29, 2006 11:10

  - 0 +
• 
  If listing features I'd like to see, this would not be one I would have thought of. I cannot think of the last time that I had to do this function, although I would be handy if I ever had to do it.
  
  I'd be more likely to use (purchase) a product that helps me a little bit all day long* instead of one that helps me once a month**.
  
  * Format Sql.
  ** Split tables into two.

  rjpaulsen August 30, 2006 19:28

  - 0 +
• 
  I, I've just installed SQL Refactor Beta and taking a look at it and I found strange that the split table feature is only for creating a 1-1 relation between the old table and the new table. Most often then not, when I want to split a table is for creating a 1-N relation; so I think it would be a great idea if we could have the option to add (or create) a new identity column in the secondary table to be used as its primary key and use the primary key of the first table as a foreign key in the secondary table.
  
  Of course, this is in some way relation to the normalisation feature that have already be mentionned in this forum.
  
  It would also be great if we could also have the possibility of directly adding new columns to the secondary table at the same occasion.
  
  Finally, as I'm not a religious person about SQL, having the possibility of doing the reverse (joining tables and/or denormalising) would be fun.

  Sylvain Lafontaine September 04, 2006 00:17

  - 0 +

Add comment

Please sign in to leave a comment.