• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

create schema in SQL 2000

create schema schematest

the above does not give an error (hit it accidentally again today)

what actually happens when it is compiled?

thanks
0
anushahanna
Asked:
anushahanna
  • 2
  • 2
2 Solutions
 
Om PrakashCommented:
Creates a schema that can be thought of as a conceptual object containing definitions of tables, views, and permissions.
http://msdn.microsoft.com/en-us/library/aa258256(SQL.80).aspx
0
 
PrakashRaoBSCommented:
Schema is nothing but its a container of objects in database.

create schema schematest
just creates a schema in the current database( the databae where the comman executed).

you can drop the schema schematest from database easily by running the following command in that particular database.


use databaseName;
drop schema schematest

Open in new window

0
 
anushahannaAuthor Commented:
om_prakash_p, you mean that in SQL 2005, right?

PrakashRaoBS, drop schema schematest gives error in SQL 2000, but create is fine..
0
 
Om PrakashCommented:
In SQL 2000
0
 
anushahannaAuthor Commented:
very interesting. thanks for that helpful info.

is CREATE SCHEMA the same as CREATE SCHEMA AUTHORIZATION?

and you could not drop DROP SCHEMA AUTHORIZATION?
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now