Visual Studio.Net Database management

right click on the tables node, you should see an option New Table

quote:Originally posted by scubabbl

I connect to my SQL database through the Visual Studio.net. I can view tables, but I can't seem to find out how to create new tables. Anyone know? Does the server explorer only allow viewing but not editing?
</blockquote id="quote"></font id="quote">

 

Did you get any error message?



quote:Originally posted by meadowstrav

I have the same problem when using the server explorer in visual studio .net. And right clicking does not give the option to add a new table. Do we have to use SQL Server 2000 Enterprise manager or what?

quote:Originally posted by scubabbl

I connect to my SQL database through the Visual Studio.net. I can view tables, but I can't seem to find out how to create new tables. Anyone know? Does the server explorer only allow viewing but not editing?
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">

 

Try get your hand on MS SQL enterprise manager.

you can get it at http://www.microsoft.com/sql/evaluation/trial/

Download the trial version and install just the client tools


quote:Originally posted by CreativeLightning

Mine is the same. I don't have the option to create a new table. I am using the Academic version of Visual Studio. I also have a connection to my local SQL server and I don't get the option with it either. It's MSDE. I am going to upgrade to the full version and see if I can get it locally.

scubabbl are you using Academic version?

gninthgiLevitaerC
</blockquote id="quote"></font id="quote">