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_General_CP1_CI_AS NOT NULL ,
[requestor] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[request_date] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[department] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[product] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[process] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[module_name] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[qef]