Create a table and put it in a file

When I create a table I can create it in a filegroup, but how do I put it in a file. Example

I have two files in one filegroup called "Secondary" file A and file B.

I want to create a new table called tableA and put it in file B on filegroup Secondary.

I looked at bookes online and can't find it.

Thanks

Thomas

Hi,

It's part of the CREATE TABLE syntax.

CREATE TABLE myTable
(myID int)
ON [Secondary]

You cannot control on which file you create it because different files in a filegroup is exactly for spreading the table over multiple files.

Kind regards