David Johnson wrote:

>
>According to SQL92 specifications ...
>
>create newtable as
> select * from oldtable;

Nope. That syntax is new in the SQL 2003 spec.

>
>
> SQL92 spec includes triggers and SP's.

Not the one I'm familiar with. Triggers were a SQL-99 feature. Stored
procedures are arguably like modules, but not nearly close enough.

Regards,


Ann