Messages

1

General Board / Re: int, identity column

« on: March 28, 2017, 01:58:13 pm »

Adding "Identity" to the Initial attributes generates the table in SQL with the word "default" which throws out an error. Can this be removed?

2

General Board / int, identity column

« on: March 28, 2017, 01:28:08 pm »

Hi all,

Does anyone know how to create a int, identity column?

e.g.
create table [dbo].[ServiceGroupLookup] (
    [ID] [int] not null identity,
    [DelayBetweenOperationsInMilliseconds] [int] not null,
    [Name] [varchar](50) not null,
    [LastModifiedByUsername] [varchar](100) not null,
    [LastModifiedDateTime] [datetime2](7) not null,
    [RecordRowVersion] [rowversion] not null,
    primary key ([ID])
);

3

General Board / Re: Create column: int identity

« on: March 09, 2016, 06:43:54 am »

Yeah I realise now that my question was a tad vague.

I guess an example of this would be:

CREATE TABLE XXX (
   ID int identity(1,1)  NOT NULL,
   Name varchar(100) NOT NULL

So adding a data type of int and including "identity" to it is what i'm after. It seems it can be done, but I can't understand how it was done.

4

General Board / Create column: int identity

« on: March 08, 2016, 08:32:24 am »

Does anyone know how to create a column with "int identity"?

5

General Board / Re: Generating Indexes

« on: September 21, 2015, 07:15:22 am »

I've tried just selecting the indexes however it still creates the tables.

6

General Board / Generating Indexes

« on: September 18, 2015, 08:42:04 am »

Is it possible when generating DDL on a table you can just generate the index(es)?

At the moment when generating a table through Code Engineering - Generate DDL it generates the CREATE TABLE as well.