Generating CREATE TABLE Script on Existing Tables in SQL Server

Q

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

✍: FYIcenter.com

A

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 > FyiCenterData > 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 [FyiCenterData]
GO
/****** Object:  Table [dbo].[tip]    
   Script Date: 05/19/2007 21:34:19 ******/
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

 

Managing Tables and Columns in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-17, 776👍, 0💬