Create Table - SQL Server 2008

Question

How can I create a table just like another one on SQL Server 2008 by using a Query, As I tried this query but it doesn't work.

Query:

CREATE TABLE MyTable AS MyOldTable

Error:

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'As'

deW1 · Accepted Answer · 2014-01-04 06:43:44Z

5

CREATE TABLE new_table AS (SELECT * FROM old_table);

Will work.

answered Jan 4, 2014 at 6:43

deW1

5,68010 gold badges42 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bogdan Sahlean Over a year ago

Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '('.

Nagaraj S · Accepted Answer · 2014-01-04 06:46:06Z

3

Try this

CREATE TABLE MyTable AS (SELECT * FROM myoldtable);

answered Jan 4, 2014 at 6:46

Nagaraj S

13.5k6 gold badges36 silver badges53 bronze badges

1 Comment

Bogdan Sahlean Over a year ago

Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '('.

Bogdan Sahlean · Accepted Answer · 2014-01-04 11:12:05Z

0

Using SQL Server Management Studio

From source table contextual menu you select Script Table as > CREATE To > New Query Editor Window: enter image description here

Then you edit the source code changing, for example, the name of table (the new name):

USE [AdventureWorks2012]
GO

/****** Object:  Table [HumanResources].[Employee]    Script Date: 1/4/2014 1:05:14 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [HumanResources].[AuditEmployee]( -- <-- Here you change table name
    [BusinessEntityID] [int] NOT NULL,
    [NationalIDNumber] [nvarchar](15) NOT NULL,
    [LoginID] [nvarchar](256) NOT NULL,
    ...

answered Jan 4, 2014 at 11:12

Bogdan Sahlean

1

Collectives™ on Stack Overflow

Create Table - SQL Server 2008

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related