How to get a table from script in sql

Vote count:

0

I have a generated script for the table. I want to use that script and use the table in another project in different machine. How to use the same table in a script format into another project?

My script table is :

USE [dbLogin]
GO

/****** Object:  Table [dbo].[tblRegistration]    Script Date: 12/29/2014 23:10:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[tblRegistration](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [UserName] [nvarchar](50) NOT NULL,
    [FirstName] [nvarchar](50) NOT NULL,
    [LastName] [nvarchar](50) NOT NULL,
    [Password] [nvarchar](50) NOT NULL,
    [Sex] [nvarchar](50) NOT NULL,
    [PhoneNumber] [decimal](18, 0) NOT NULL,
    [DOB] [datetime] NOT NULL,
    [City] [nvarchar](50) NOT NULL,
    [State] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_tblRegistration] PRIMARY KEY CLUSTERED 
(
    [Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO 

edited 1 min ago

marc_s

346k

asked 2 mins ago

Chinthu

1

How to get a table from script in sql