creating a table as dbo syntax

[joneil3]

hi,

I'm looking to create a table as database dbo in sql query analizer - does anyone know the syntax - scrap_user has dbo priviliges

CREATE TABLE [scrap] (

[scrap_id] [int] IDENTITY (1, 1) NOT NULL ,
[lot] [nvarchar] (15) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NOT NULL ,
[requestor] [nvarchar] (30) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[request_date] [nvarchar] (20) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[department] [nvarchar] (30) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[product] [nvarchar] (15) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[process] [nvarchar] (10) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[module_name] [nvarchar] (20) COLLATE SQL_Latin1_Gene ral_CP1_CI_AS NULL ,
[qef]

[scripto]

if your role is db_owner then
CREATE TABLE dbo.tablename
( .....)

if you only have permission to create tables then you cannot create a table as dbo