Answers

Question and Answer:

  Home  MS SQL Server

⟩ How To Generate CREATE TABLE Script on an Existing Table in MS SQL Server?

If you want to know how an existing table was created, you can use SQL Server Management Studio to automatically generate a "CREATE TABLE" script The following tutorial shows you how to do this:

1. Run SQL Server Management Studio and connect to SQL server.

2. On the Object Explorer window, follow the object tree: Databases > GlobalGuideLineDatabase > Tables > dbo.tip.

3. Click right mouse button on dbo.tip. The context menu shows up.

4. Select "Script Table as" > "CREATE to" > "New Query Editor Window". The following script will be displayed:

USE [GlobalGuideLineDatabase]

GO

/****** Object: Table [dbo].[tip]

Script Date: 05/05/2008 11:34:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tip](

[id] [int] NOT NULL,

[subject] [varchar](80)

COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[description] [varchar](256)

COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[create_date] [datetime] NULL,

PRIMARY KEY CLUSTERED (

[id] ASC

)WITH (PAD_INDEX = OFF,

IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

 172 views

More Questions for you: