Are you looking for sys.schemas? IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name=”jim”) BEGIN EXEC(‘CREATE SCHEMA jim’) END Note that the CREATE SCHEMA must be run in its own batch (per the answer below)
Mike Sherrill ‘Cat Recall’ gave an excellent answer. I’ll add simply one example: Postgres. Cluster = A Postgres Installation When you install Postgres on a machine, that installation is called a cluster. ‘Cluster’ here is not meant in the hardware sense of multiple computers working together. In Postgres, cluster refers to the fact that you … Read more
See Is there a version control system for database structure changes? How do I version my MS SQL database in SVN? and Jeff’s article Get Your Database Under Version Control I feel your pain, and I wish there were a better answer. This might be closer to what you were looking for. Mechanisms for tracking … Read more
I found SchemaSpy quite good – you have to run the script every time schema changes but it is not so big deal. As pointed out in the comments there is also a GUI for it. Another nice tool is SchemaCrawler.
the Microsoft XSD inference tool is a good, free solution. Many XML editing tools, such as XmlSpy (mentioned by @Garth Gilmour) or OxygenXML Editor also have that feature. They’re rather expensive, though. BizTalk Server also has an XSD inferring tool as well. edit: I just discovered the .net XmlSchemaInference class, so if you’re using .net … Read more
You should take a look at pg_dump: pg_dump -s databasename Will dump only the schema to stdout as .sql. For windows, you’ll probably want to call pg_dump.exe. I don’t have access to a Windows machine but I’m pretty sure from memory that’s the command. See if the help works for you too.
This is in the Xcode documentation available from the “Help” menu. Choose “Help” > “Xcode Help”, then enter “rename scheme” to find it. Here are the steps: Choose “Edit Scheme” from the “Product” menu. Click on the “Manage Schemes…” button Select the scheme whose name you wish to change Press the “Return” key It will … Read more
You can declare trk by the following ways : – either trk : [{ lat : String, lng : String }] or trk : { type : Array , “default” : [] } In the second case during insertion make the object and push it into the array like db.update({‘Searching criteria goes here’}, { $push … Read more
GRANTs on different objects are separate. GRANTing on a database doesn’t GRANT rights to the schema within. Similiarly, GRANTing on a schema doesn’t grant rights on the tables within. If you have rights to SELECT from a table, but not the right to see it in the schema that contains it then you can’t access … Read more
From the Differences Between DTDs and Schema section of the Converting a DTD into a Schema article: The critical difference between DTDs and XML Schema is that XML Schema utilize an XML-based syntax, whereas DTDs have a unique syntax held over from SGML DTDs. Although DTDs are often criticized because of this need to learn … Read more