If you're a member of the db_dbowner or db_ddladmin fixed database roles than you can create a table with dbo as an owner

CREATE TABLE myDB.dbo.ctest3
...

>I am using Visual Foxpro to programmatically create a table in a SQL Server database. The following works fine except that the table is created with my userid as the owner. What I really what is for the owner to be DBO.
>
>How can I change the following syntax to create the table with an owner of DBO?
>
>

>Text to lc_sql textmerge noshow
>CREATE TABLE [ctest3] (
>	[cname] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
>) ON [PRIMARY]
>ENDTEXT
>
>=SQLEXEC(myconn, lc_sql)
>

>