|
-
Dec 23rd, 2018, 01:03 AM
#1
Thread Starter
Junior Member
how create a new table in db in host?
hello
i have a database in my host. i want to create a new table in it.
first method is that download db from host then create new table then upload it to host.
but there is an expense.
i want to create a new table without download and upload db from/to host.
the below is code of create table in localhost db. how can i change it to run in host.
is there a new method for this idea?
USE [ASPNETDB]
GO
/****** Object: Table [dbo].[Login_tbl] Script Date: 12/22/2018 07:38:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Login_tbl](
[id] [int] IDENTITY(1,1) NOT NULL,
[Username] [nvarchar](50) NULL,
[Password] [nvarchar](50) NULL,
CONSTRAINT [PK_Login_tbl] 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
thanks
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|