Collections:
Generating CREATE TABLE Script on Existing Tables in SQL Server
How To Generate CREATE TABLE Script on an Existing Table in SQL Server?
✍: FYIcenter.com
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
⇒ "SELECT ... INTO" - Creating New Tables With Queries in SQL Server
⇐ "sp_help" - Getting a List of Columns in a Table in SQL Server
2016-11-17, 2988🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...