
May 5th, 2004, 11:42 AM
|
|
Registered User
|
|
Join Date: Jan 2004
Posts: 20
Time spent in forums: 1 m 33 sec
Reputation Power: 0
|
|
|
ASP.NET Enterprise Manager - Create Table Problems
Hi.
I just signed up a client to a hosting company that uses ASP.NET Enterprise Manager to manage their databases. I am using the "Run a Query" section to just do SQL commands. I seem to be having a problem though trying to create a table. This is what I am inputing:
CREATE TABLE test (id int(11));
I have found the int() doesn't work with Enterprise Manager. I am used to just using MySQL and I am finding this Enterprise Manager to be quite a pain. Yes it offers a point and click solution, but for me, I just want the command prompt.
Can anyone help me out as to what I should do to create an integer column. I will need the SQL code for it because the site I am designing will be creating and dropping tables constantly.
Thanks
Wes
|