Table

• Jr.DBA

  Old Hand

  Points: 339

  More actions

  July 16, 2008 at 1:30 pm

  #195296

  Hi,

  Can anybody let me know that how we can create table on secondary file group?

  Thanks

• Animal Magic

  SSChampion

  Points: 13964

  More actions

  July 16, 2008 at 1:38 pm

  #844034

  assuming you have created your secondary file group (lets call it second) you can use this

  Create table dbo.MyTable

  (

  col1 int,

  col2 varchar(10)

  ) on Second