B bitd Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-20 #1 如何在interbase中建索引？在程序中如何用？说得详细点好吗？ 分虽然不多，但希望得到你的帮助
H huawdg Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-21 #2 例如，在QUERY的SQL中： CREATE [UNIQUE] [ASC[ENDING] | DESC[ENDING]] INDEX index ON table (col [, col ]);
H huawdg Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-22 #4 1.建表时建主索引 CREATE TABLE MyTable ( FIELD1 INTEGERNOT NULL, FIELD2 INTEGER NOT NULL, FIELD3 INTEGER NOT NULL, FIELD4 INTEGER NOT NULL, FIELD5 INTEGER, PRIMARY KEY (FIELD1,FIELD2) ) 2.建从索引 CREATE UNIQUE ASC INDEX SecondIndex ON MyTable (FIELD3,FIELD4) 3.对已建表建立主索引 ALTER TABLE MyTable ADD PRIMARY KEY(FIELD1,FIELD2)
1.建表时建主索引 CREATE TABLE MyTable ( FIELD1 INTEGERNOT NULL, FIELD2 INTEGER NOT NULL, FIELD3 INTEGER NOT NULL, FIELD4 INTEGER NOT NULL, FIELD5 INTEGER, PRIMARY KEY (FIELD1,FIELD2) ) 2.建从索引 CREATE UNIQUE ASC INDEX SecondIndex ON MyTable (FIELD3,FIELD4) 3.对已建表建立主索引 ALTER TABLE MyTable ADD PRIMARY KEY(FIELD1,FIELD2)
G guyigood Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-23 #5 在QUERY的SQL中 create indexname on tablename(filedname)
Y yczjs Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-23 #6 龙豪InterBase社区不错 里面有不少这方面的教程 http://www.3asoft.com
