-
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
-
Dec 23rd, 2018, 02:08 AM
#2
Re: how create a new table in db in host?
If you're talking about a commercial web host then they would generally provide either an online admin portal or else you can remotely connect to the database via Management Studio. You should contact your hosting provider to find out how to manage databases on their system.
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
|