Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 joininig 2 SQL queries ,possible??

Author  Topic 

leo83
Starting Member

1 Post

Posted - 2008-04-25 : 09:07:15
Hello all,

Is it possible to create a database, Schema, table all at once using one SQL query.
or atleast a database and Schema using a single query.

Eg: Create database "Max", Create schema "min" .

please reply,
Thanks
Abhi

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-25 : 09:43:04
No.
In a "batch" the answer is yes.

CREATE DATABASE ...
GO
CREATE SCHEMA ....




E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -