>Hi Sergey,
>
>for simplified recreation of one sql object
>( i have developer a VFP_MSQL integrated framework support builder ).
>
>Before CREATE ... i need:
>
>>IF (SELECT OBJECT_ID('objectName')) IS NOT NULL
> DROP <OBJECTTYPECLAUSE> objectName
>
>CREATE <OBJECTTYPECLAUSE>
>
>
>Better it would be :
>> DROP objectName
>
I don't see why it's better. Anyway you know what type of object you're working with.
>Best of the Best ( like on CREATE INDEX )
>>CREATE TABLE TableName ... WITH DROP_EXISTING
>
That would be very usefull and convinient.
>You known where found new MSQL Yukon TSQL language enhancement ?In the Yukon beta program. :)
--sb--