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