Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Generating CREATE TABLE Script on Existing Tables

By: FYIcenter.com

(Continued from previous topic...)

How To Generate CREATE TABLE Script on an Existing Table?

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

(Continued on next topic...)

  1. What is a table?
  2. What are DDL (Data Definition Language) statements for tables?
  3. How to create new tables with "CREATE TABLE" statements?
  4. How To Get a List of All Tables with "sys.tables" View?
  5. How To Get a List of Columns using the "sys.columns" View?
  6. How To Get a List of Columns using the "sp_columns" Stored Procedure?
  7. How To Get a List of Columns using the "sp_help" Stored Procedure?
  8. How To Generate CREATE TABLE Script on an Existing Table?
  9. How to create new tables with "SELECT ... INTO" statements?
  10. How To Add a New Column to an Existing Table with "ALTER TABLE ... ADD"?
  11. How To Delete an Existing Column in a Table with "ALTER TABLE ... DROP COLUMN"?
  12. How to rename an existing column with the "sp_rename" stored procedure?
  13. How to rename an existing column with SQL Server Management Studio?
  14. How to change the data type of an existing column with "ALTER TABLE" statements?
  15. How to rename an existing table with the "sp_rename" stored procedure?
  16. How To Drop an Existing Table with "DROP TABLE" Statements?

Related Articles:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...