Re: Is there a SQL92 compliant CREATE TABLE statement?

Hi Johann,

I think CREATE TABLE is in fact standardized. But only the core. So your CREATE TABLE t(c1 INT); is likely compliant. But as sson as you get into more advanced features or the intercation between the SQL level and teh physical mapping (such as tablespaces) you're likely in vendor specific terrain. Maybe if you take a look at the book "SQL99 complete, really" (OK, not SQL92,...)
you'll find the information you look for.

Cheers
Serge

--
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Canada