How to insert in a table having a single column which is unique?

Question

I am having a table which is having a single column which in unique as set ~~auto incremented~~ IDENTITY on. how to insert in that table ? or how to insert a new row in that table? i wanna use that row as a counter.

Edited:

This is my table schema:

CREATE TABLE [dbo].[extra](
    [id] [int] IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

I am using sql server.

insert into extra(id) values (default).

This query showing an error.

we would need more specifics . which rdbms and version? your question is very vague — ughai, Jun 05 '15 at 06:05

score 1 · Accepted Answer · answered Jun 05 '15 at 06:05

1

The same way you would insert in any other table:

insert into [tableName] default values;

answered Jun 05 '15 at 06:05

Luaan

62,244
7
97
116

i cant insert a value? table having only a single column. which is auto incremented. – waleedansari Jun 05 '15 at 06:07
@waleedansari That's why the `default values` is there. – Luaan Jun 05 '15 at 06:18

How to insert in a table having a single column which is unique?

1 Answers1