Mr Brian Gale,

You were spot on. Thanks so much mate

Mr Brian Gale,

Thanks so much for this, as this has been driving me crazy trying to understand why I'm getting the error.

OK, I going to test it with INT IDENTITY...

Hi Mike01

Thanks for getting back to me:

Here you go.

CREATE TABLE [CP-PretBIHydr8Config].Config.Entities (

EntityID INT NULL

,EntityName VARCHAR(250) NULL

,EntityType VARCHAR(50) NULL

,Classification INT NULL

,Area VARCHAR(150) NULL

,Domain VARCHAR(150) NULL

,Version INT NULL

,BusinessDomain VARCHAR(50) NULL

,Active BIT NULL

)

I...

Got Yer.

Thanks

Hi Phil,

Thanks for support with this. Hopefully, someone will help in your absence.

ColumnType is manually entered

Hi Phil,

The following sample code my help...

CREATE TABLE #tmpTable (
    EntityColumnID int,
    EntityID int,
    EntityColumnOrder int,
  ...

With regard to the EntityID, I will create manually...

Phil,

Yes, that is exactly what I want.... I couldn't have explained it better myself..

Can you please, please help me with that?

Hi Phil

Does this make sense?

Hi Phil,

Thanks for reaching out.

I know my question is a little confusing.

Basically, I would want the columns inserted as follows:

Don't worry.

I realised the problem was that I didn't have a schema called called Config in the first place - doh!

Hi Phil,

I just tried changing the schema with the username that was used to actually create the database but I'm still getting the error

Cannot alter the schema 'Config', because it...

Sorry, I'm being an idiot.

I'm getting the following error

Msg 15151, Level 16, State 1, Line 1

Cannot alter the schema 'Config', because it does not exist or you do not have...

Hi Phil,

Thanks for getting in touch,

I pasted the code into SSMS but the schema remains the same

Perfect.

Thanks