Greetings!

Using version 5.6.2

Is there a way I can specify, in the designer, attributes to be used on a column in the generated DDL script?

My generated script is:

CREATE TABLE [dbo].[Photo] 
(
    [Jpg] [varbinary](MAX) NULL, 
    [Id] [uniqueidentifier] NOT NULL 
)
GO

but what I want is:

CREATE TABLE [dbo].[Photo] 
(
    [Jpg] [varbinary](MAX) FILESTREAM NULL, 
    [Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE
)
GO

(Yes, I know about the work-around in Llblgen for using FILESTREAM. But here, I just want to create it.)

This isn't possible at the moment. We'll add a workitem for it for a future version

Bummer for now, but Ooo cool! in the future then.

Thanks for the answer!