We know that SQL Azure is a somewhat stripped down version of MS SQL. Things like create a diagram or edit a table don’t exist in the cloud. Everything is using straight T-SQL to get things done.

Its best when creating a new application with tables and relationships to do that work locally. When we are ready to move our SQL tables to SQL Azure I right click the table and create a new table. Connect to SQL Azure and run the query. Howver this error comes up;

‘Filegroup reference and partitioning scheme’ is not supported in this version of SQL Server.’

The solution is to remove the two “ON [PRIMARY]” parts of the create statement. Now run your query without error.