• Yes it can.

    Create table [schema].[name] (Id int identity(1,1) primary key clustered)