Make Index field !

[HadiRezaee]

Hi all,
I maked a table and three fields inside the table ...
How can i make a field as Index Field ?
I must use CREATE INDEX statment ?

 

[SA812]

I'm not sure if this is what you need. I think your trying to create a Index field. In Access i used an autonumber, but when i converted to SQL i needed to use the identity key. Make sure the data type is "int". Make sure following match in the Columns info.:
Indentity "YES"
Indentity Seed "Leave blank or put a # in" If you wanted the index to start with 2000 you should put 2000 in there.
Identity Increments "1" this will the index field grow by one after each record.
Also try doing a help search on "Columns property page" it explains it in there as well
Hope this helps

 

[DrewConn]

If you are using SQL server EM open the table that has the field you want to index.

Right click on the field and select properties.

Select new. Rename the index name is you want to something more meaningful. Select the field you want to index in the dropdown list.

Hope this helps.

 

[tlbroadbent]

Hadi,

You can also use the Create Index statement in T-SQL to create an index on one or more columns in the table.

Example: Create clustered index on 1 column
Create Clustered Index IxEmpName
On tblEmployees (EmpName)

Example: Create unique index on 3 columns
Create Unique Index IxPartNo
On tblPartInfo (PNBody, PNSfx, PNPfx) Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm