How do I set the type of geometry when creating a SQL table?

Question

The table I am trying to recreate has these properties

Data Type      File Geodatabase Feature Class
Feature Type   Simple
Geometry Type  Polygon    <<<< WHAT I WANT TO RECREATE

My target SQL table is this:

CREATE TABLE [dbo].[MyAggregateTable](
    [OBJECTID] [int] IDENTITY(1,1) NOT NULL,
    [SHAPE] [geometry] NULL,
    [Status] [nvarchar](25) NULL,
    ...

And the resulting properties are:

Data Type      Enterprise Database Feature Class
Feature Type   Simple
Geometry type  Any         <<<< NOT THE SAME!

FURTHER PROGRESS / EDIT

Now I have discovered that I can manipulate the geometry type by using the ArcCatalog App. I can change the Type to "Polygon Features" manually on the FeatureClass properties - but it's not permanent. As soon as I exit, it 'forgets'.

Then I dicovered that if I manually "Load Data" in the ArcCatalog App, the FeatureClass properties are set, the data is loaded, and we are good to go.

However, if I flush the table, (not DROP), the geometry type reverts back.

So basically a SearchCursor / InsertCursor approach does not work >>> it has to be done manually.