[dba-SQLServer] Create table within schema

Gustav Brock gustav at cactus.dk
Wed Aug 22 09:34:19 CDT 2012


Hi Arthur

Open the Properties window in table design.

Near the top in this, I have the property Schema with a combobox to select from the available schemas.

/gustav


>>> fuller.artful at gmail.com 22-08-12 15:34 >>>
Using SSMS, how does one create a table within a schema? (It's simple
enough without the GUI, but when I use the GUI, even if I name a table,
say, Arthur.MyTable, once I save it, it's called dbo.Arthur.MyTable. Is
there a way within the GUI to specify the schema to use first and then
create its tables?

-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr



More information about the dba-SQLServer mailing list