MSSQL Interview Questions and Answers
Question: How To Generate CREATE TABLE Script on an Existing Table in MS SQL Server?Answer: 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 > WithoutbookDatabase > Tables > dbo.wb. 3. Click right mouse button on dbo.wb. The context menu shows up. 4. Select "Script Table as" > "CREATE to" > "New Query Editor Window". The following script will be displayed: USE [WithoutbookDatabase] GO /****** Object: Table [dbo].[wb] 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].[wb]( [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 |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft SQL Server?
- What is the simplest way to create a new database in MS SQL Server?
- How to delete a database in MS SQL Server?
- How to download and install Microsoft .NET Framework Version 2.0?
- How To Get a List of Columns using the "sp_help" Stored Procedure in MS SQL Server?