creating a table in a database

Question

0.00/5 (No votes)

See more:

SQL-Server

Can i create a table in a database without using sql server management studio??

Posted 15-May-12 1:20am

Rahul GS

Add a Solution

Comments

uspatel 15-May-12 7:22am

where you want to create database on remote server,or you have local instance of sql server?

Rahul GS 15-May-12 7:24am

i dont have management studio....

uspatel 15-May-12 7:27am

You dont need Mgmt studio but you should have sql server instance running on remote machine or on local machine.....

Rahul GS 15-May-12 7:28am

only confgrtn tool is der in my pack

4 solutions

Solution 2

Yeah, Ofcourse
just execute following command

SQL

CREATE TABLE abc
(
Id int not null,
name varchar(50) null,
sirname varchar(50) null,
place varchar(50) null
)

Then for insert records

SQL

insert into abc values(1,'Radhe','shyam','chandigarh')

Posted 15-May-12 1:28am

sunandandutt

Updated 15-May-12 1:39am

v2

Solution 3

SQL

create table "Table name"("Column name1" "datatype")

eg.

SQL

create table Test(name varchar(50))

Posted 15-May-12 1:41am

Reegan Durai.m

Updated 15-May-12 1:44am

v2

Solution 4

By using microsoft access we can create database

Posted 15-May-12 1:49am

Prasanna Kumari

Comments

Rahul GS 15-May-12 7:57am

can i create a table???

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mario Majčica · Accepted Answer · 2012-05-15T01:23:00

Solution 1

Sure, you can execute the following query:

SQL

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type,
column_name3 data_type,
....
)

an concrete example is:

SQL

CREATE TABLE Persons
(
P_Id int,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)

Cheers

Posted 15-May-12 1:23am

Mario Majčica

Comments

Rahul GS 15-May-12 7:26am

sir,
wer i want write this?

Mario Majčica 15-May-12 7:28am

In you application I suppose, you didn't wrote down anything about your problem more in detail.

Mario Majčica 15-May-12 7:32am

Beside, there are many ways of executing a query, these are some of them:
http://sourceforge.net/projects/queryexplus/
http://toadworld.com/SQLSERVER/tabid/760/Default.aspx
http://versabanq.com/products/squel.php
http://msdn.microsoft.com/en-us/library/ms162773.aspx

etc.

Why should you not use SSMS??? There is an free version of it.

Cheers

Rahul GS 15-May-12 7:37am

only confgrtn tool is der in my sql pack.....no mangamnt stdio

Mario Majčica 15-May-12 7:42am

Try to be more precise. Are you speaking about MS SQL, what are your limitations and your needs?

Cheers

Rahul GS 15-May-12 7:51am

ys sir,..im using microsft sql server...i want to create table in master database..but i dont hav managmnt studio.......

Mario Majčica 15-May-12 7:52am

Download the express version of it and enjoy:

http://www.microsoft.com/en-us/download/details.aspx?id=1695

Rahul GS 15-May-12 8:03am

sir i hav anothr doubt....I developed a windows form application using c#.and i created a .exe(setup) file.it is running in my system.i want to install on another system which does not contain sql server.i want to install sql server along with the .exe file.how to include sql server during setup creation.how to add my data base to the set up...

thanks sir....

Mario Majčica 15-May-12 8:06am

You will need to installa manually SQL Serve, but the DB you can still deploy it via installer. Check this out:

http://www.codeproject.com/Articles/10032/Deploy-SQL-Server-databases-easily-with-an-Install

Mario Majčica 15-May-12 8:07am

Also this can be helpful

http://www.codeproject.com/Articles/16231/Deploy-your-Application-and-Database

Rahul GS 15-May-12 8:07am

Thank u very much sir..:)

Rahul GS 15-May-12 8:17am

sir..how to use installer class perfctly...any step by step explntn that discrbs using instalr clas ...plsrply..:)

creating a table in a database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

creating a table in a database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us