How do (if I can) run a query to set-up the tables in ASP.Net Enterprise Manager?
If it is not possible is there something else I can use - bearing in mind that my service provider who hosts my site has loaded this?
Thank You!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I guess you could just execute a Create Table statement.
The simplest form would be something like:
CREATE TABLE [dbo].[CandidateSkill](
[CandidateId] [bigint] NOT NULL,
[SkillId] [smallint] NOT NULL,
[SkillLevel] [tinyint] NOT NULL)
This is just a quick example from one of my tables. There's lots of SQL syntax
to learn if you want to set up primary keys, foreign key constraints etc etc etc.
(I assume you know that you can create tables using the ASP.Net Enterprise Manager's
functionalities.)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
How do (if I can) run a query to set-up the tables in ASP.Net Enterprise Manager?
If it is not possible is there something else I can use - bearing in mind that my service provider who hosts my site has loaded this?
Thank You!
I guess you could just execute a Create Table statement.
The simplest form would be something like:
CREATE TABLE [dbo].[CandidateSkill](
[CandidateId] [bigint] NOT NULL,
[SkillId] [smallint] NOT NULL,
[SkillLevel] [tinyint] NOT NULL)
This is just a quick example from one of my tables. There's lots of SQL syntax
to learn if you want to set up primary keys, foreign key constraints etc etc etc.
(I assume you know that you can create tables using the ASP.Net Enterprise Manager's
functionalities.)