Kbase P89287: How to create a table with a PRIMARY KEY using SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/07/2004 |
|
Status: Unverified
GOAL:
How to create a table with a PRIMARY KEY using SQL-92?
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
OpenEdge 10.x
FIX:
To create an SQL-92 table, the user needs to have RESOURCE privilege. The following SQL-92 code creates an SQL-92 table with a PRIMARY KEY:
CREATE TABLE myCustomer
(
myCustNum INTEGER NOT NULL PRIMARY KEY,
myCustname CHAR(30)
)
AS SELECT
Custnum,
Name
FROM
PUB.CUstomer;
COMMIT;