Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dgaylor
Yak Posting Veteran
54 Posts |
 Posted - 2002-02-13 : 22:31:37
|
| is it possible to use the 'select into' statement to create a table, but also specify which filegroup you want the table to be created in? thanks |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-02-13 : 22:51:03
|
| Unfortunately SQL Server creates all tables from this clause in the Default File Group...If this is just a once off.. perhaps you could change the default file group.. Insert.. then change back.or CREATE TABLE on the filegroup and INSERT...SELECTHTHDavidMTomorrow is the same day as Today was the day before.Edited by - byrmol on 02/13/2002 22:52:10 |
 |
|
|
ToddV
Posting Yak Master
218 Posts |
Posted - 2002-02-14 : 09:21:10
|
| You could also create it with select into and then move it by creating clustered index in non default file group. |
|
|
|
|
|
|
select into and filegroups