Create table issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Create table issue

Author

Topic

helixpoint
Constraint Violating Yak Guru

291 Posts

Posted - 2007-10-11 : 07:51:48

I am trying to create a table threw c# app, but is adds the user as the owner instead of the dbo to the table. Here is the slg code

CREATE TABLE [Zipcodes] (
[ZIP_CODE] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[CITY] [varchar] (26) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[STATE] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[COUNTYFIPS] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY];

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-10-11 : 07:54:39

quote:
Originally posted by helixpoint

I am trying to create a table threw c# app, but is adds the user as the owner instead of the dbo to the table. Here is the slg code

CREATE TABLE dbo.[Zipcodes] (
[ZIP_CODE] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[CITY] [varchar] (26) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[STATE] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[COUNTYFIPS] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY];

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

helixpoint
Constraint Violating Yak Guru

291 Posts

Posted - 2007-10-11 : 08:01:02

Ya
CREATE TABLE dbo.Zipcodes (
worked. I saw that after I posted. Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources