Returns the datatype, table name and field name for all user tables in the current SQL Server 2005 database. Results are sorted by type, table and field.
2007-01-08 (first published: 2006-12-05)
107 reads
This script has been on the SQL Server Central site for a while and has been revised a number of times. I enclose yet another revision that works with SQL Server 2005 (June CTP anyway) with much thanks to all those who have contributed to it in the past.Terry Grignon
2006-02-08 (first published: 2005-11-11)
1,089 reads
I do a lot of SQL Server Desktop Edition instance testing and I cobbled together this script from BOL and other scripts I've seen posted. It is intended to show version, service pack level, machine and instance name and the security type among other information. Hopefully someone else may find it of use.
2003-02-27
252 reads
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Comments posted to this topic are about the item Adding and Dropping Columns II
Comments posted to this topic are about the item Leveraging DuckDB for OLAP Workloads:...
Comments posted to this topic are about the item More Documentation is Needed
I have this table in my SQL Server 2022 database:
CREATE TABLE [dbo].[CityList] ( [CityNameID] [int] NOT NULL IDENTITY(1, 1), [CityName] [varchar] (30) , [Country2] [char] (3), [stateprovince2] [char] (2), [Country] [char] (3), [stateprovince] [char] ) ON [PRIMARY] GOI decide to drop the stateprovince2 and country2 columns. What code should I use? See possible answers
