[dba-SQLServer] SQL Server 2005 - Set default data types

jwcolby jwcolby at colbyconsulting.com
Fri Nov 23 11:18:45 CST 2007


 Is there a way to set the defaults for data types in SQL Server 2005 when
creating tables.  IOW, if I set a column to char() can I make it Char(1)
instead of Char(10)?  If so how?


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Friday, November 23, 2007 12:08 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] SQL Server 2005 - View to table

No you wouldn't! SELECT INTO creates the table.

On 11/23/07, jwcolby <jwcolby at colbyconsulting.com> wrote:
>
> Indeed why not?  The only real reason is that newTable does not exist 
> yet and I would have to create it by hand.
>
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list