Syntax for INSERTing into a table with no values?

sql sql-server tsql insert
David Pfeffer picture David Pfeffer · Jan 27, 2010 · Viewed 23.5k times · Source

I have a table created with the following schema:

CREATE TABLE [dbo].[Visualizations]
(
    VisualizationID     int identity (1,1)      NOT NULL
)

Since the table has no settable fields, I'm not sure how to insert a record. I tried:

INSERT INTO [Visualizations];
INSERT INTO [Visualizations] () VALUES ();

Neither work. What is the proper syntax to do this?

Edit: Since a number of people seem confused by my table, it is used purely to represent a parent of a number of sub-tables... each one references this table by FK and each of those FKs are PKs, so that across all of those tables, the IDs are unique.

Answer

Anton Gogolev picture Anton Gogolev · Jan 27, 2010

See this (example "F. Load data using the DEFAULT VALUES option"):

INSERT INTO [Visualizations] DEFAULT VALUES;

Related questions

Inserting multiple rows in a single SQL query?

I have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and Office. INSERT INTO MyTable VALUES ("John", 123, "Lloyds Office"); INSERT INTO MyTable VALUES ("Jane", 124, "Lloyds Office"); INSERT INTO MyTable VALUES ("Billy", 125, "…

Read More
Add row to query result using select

Is it possible to extend query results with literals like this? select name from users union select name from ('JASON'); or select age, name from users union select age, name from (25,'Betty'); so it returns all the names in the …

Read More
How can I INSERT data into two tables simultaneously in SQL Server?

Let's say my table structure looks something like this: CREATE TABLE [dbo].[table1] ( [id] [int] IDENTITY(1,1) NOT NULL, [data] [varchar](255) NOT NULL, CONSTRAINT [PK_table1] PRIMARY KEY CLUSTERED ([id] ASC) ) CREATE TABLE [dbo].[table2] ( [id] [int] IDENTITY(1,1) NOT NULL, [table1_…

Read More