I have a local sql database thati am comparing to the SQL Azure. Script is generated but when i run it in Azure i get the following issue...
Msg 40054, Level 16, State 2, Line 1
Tables without a clustered index are not supported in this version of SQL Server. Please create a clustered index and try again.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.
Is there an option to say that it must conform to SQL Azure?
Require urgent advice if possible,