manually create table by writing new query to particular database

Question

0.00/5 (No votes)

See more:

In my sql server if i write a create table query and execute it, the table is placed in some were else, i want that table in particular database .
thanks .

Posted 9-Jul-13 23:48pm

prasadhp

Add a Solution

2 solutions

Solution 2

Pls try this

SQL

CREATE TABLE [MyDatabaseName]..[TestTable]
(
	ID VARCHAR(50) NOT NULL,
	NAME VARCHAR(50)
	
)

hope this helps...

Posted 9-Jul-13 23:59pm

jomon_raju

Add a Solution

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

Adarsh chauhan · Accepted Answer · 2013-07-09T23:52:00

Solution 1

Try this

SQL

USE [DataBaseName]
GO

CREATE TABLE tableName
(
    columnName datatype,
     columnName datatype,
    columnName datatype

)

GO

Posted 9-Jul-13 23:52pm

Adarsh chauhan

Comments

prasadhp 10-Jul-13 6:03am

is it necessary to writ go

Adarsh chauhan 10-Jul-13 6:09am

No its not necessary to write 'go'.

GO is used to signal the end of a batch.
GO is not a Transact-SQL statement; it is a command recognized by the sqlcmd and osql utilities and SQL Server Management Studio Code editor.

manually create table by writing new query to particular database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

manually create table by writing new query to particular database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us