Results 1 to 2 of 2

Thread: how create a new table in db in host?

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Oct 2018
    Posts
    25

    Question 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

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,297

    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
  •  



Click Here to Expand Forum to Full Width