Kbase P72505: Can I create a table without index in Progress SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
17/03/2004 |
|
Status: Unverified
GOAL:
Can I create a table without index in Progress SQL-92?
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
OpenEdge 10.x
FIX:
Yes. Below the contents of a SQL-Explorersession log representing a small test:
=== Start === Wed Mar 17 15:35:25 GMT+01:00 2004
create table test (
FirstName varchar(30) ,
LastName varchar(50) ,
State varchar(50) ,
Sport char(20)
)
=== End === Wed Mar 17 15:35:25 GMT+01:00 2004
=== Start === Wed Mar 17 15:35:25 GMT+01:00 2004
commit work
=== End === Wed Mar 17 15:35:25 GMT+01:00 2004
=== Start === Wed Mar 17 15:36:12 GMT+01:00 2004
insert into test (Firstname) values('Reinhard')
=== End === Wed Mar 17 15:36:12 GMT+01:00 2004
=== Start === Wed Mar 17 15:36:12 GMT+01:00 2004
commit
=== End === Wed Mar 17 15:36:12 GMT+01:00 2004
=== Start === Wed Mar 17 15:36:59 GMT+01:00 2004
select * from test
FIRSTNAME LASTNAME STATE SPORT
------------------------------ -------------------------------------------------- -------------------------------------------------- --------------------
Reinhard
=== End === Wed Mar 17 15:36:59 GMT+01:00 2004