DTS - Create Index On DBF File

Question

DTS - Create Index On DBF File

JuanBob

SSCertifiable

Points: 5059
More actions
April 16, 2007 at 2:31 pm

#195115

Is there any way to create an Index on a DBF file with T-SQL or DTS? I have an application outside of SQL that can create indexes, but it would be much easier if I could do this along with the CREATE TABLE task.
Thanks!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Adrian Nichols-360275 SSCertifiable Points: 7694 More actions · Answer 1

Hi,

Are you using a linked server to connect to the dbf file and are looking to create and index on one or all of the tables? Or have I completely missed the question?

Ade

A Freudian Slip is when you say one thing and mean your mother.
For detail-enriched answers, ask detail-enriched questions...[/url]

JuanBob SSCertifiable Points: 5059 More actions · Answer 2

In my DTS package, I have a connection to a dBase IV file that's out on the network. With that connection, I initiate the Create Table task.

Thanks!

Adrian Nichols-360275 SSCertifiable Points: 7694 More actions · Answer 3

Have a look at CREATE INDEX in bol.

You should be able to do something like:

CREATE INDEX ix_myIndex ON myTable( myCol1, myCol2, myCol3....)

after your CREATE TABLE statement.

Ade

A Freudian Slip is when you say one thing and mean your mother.
For detail-enriched answers, ask detail-enriched questions...[/url]

JuanBob SSCertifiable Points: 5059 More actions · Answer 4

Yes and I have tried it in many different ways and formats. Maybe it's just not possible. It seems like SQL 2005 may be able to do this. I have a workaround, it's just not as reliable as it would have been in SQL.

Thanks for the follow-up!