Re^2: T-SQL problem - Perl solution?

Two minor nits;

This works for MSSQL 2000, but may break with MSSQL 2005
The type column exists for backward compatibility only; xtype is the right column (if you must). They are different.

Comment on Re^2: T-SQL problem - Perl solution?

Replies are listed 'Best First'.
Re^3: T-SQL problem - Perl solution? by mpeppler (Vicar) on Oct 25, 2004 at 12:25 UTC
Thanks. I'm not really an MS-SQL user - I just apply the Sybase syntax, which usually works (though it looks like MS is moving in a different direction for system tables...) Michael	[reply]
Re^3: T-SQL problem - Perl solution? by gellyfish (Monsignor) on Oct 25, 2004 at 12:27 UTC
To be fair that is almost exactly what SQL Server 2000 emits in a new CREATE TABLE template if you have specified that you should create the appropriate DROP TABLE ... /J\	[reply]