Technical Article

How to get ColumnNames, datatypes and length

This is a followup to the script submitted by srallapalli. One can return a record set of all tables in a database using the following:USE MyDatabaseSELECT so.name AS TableName, sc.name AS ColumnName,  st.name AS ColumnDatatype,  convert(int, sc.length) AS ColumnLength FROM syscolumns sc, sysobjects so , systypes st WHERE so.type='U' AND OBJECTPROPERTY(so.id,'ismsshipped') = 0 AND sc.id=so.id […]

2003-05-10

138 reads

Blogs

Scary Scalar Functions - Part Four: Your Environment

By

Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...

Being a script magpie

By

Last month (I ran just a little bit late writing this, it was meant...

Community Tools Month 2022 - dbatools

By

The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...

Read the latest Blogs

Forums

Calling stored procedure to bulk import from SSIS causes access denied

By markdummen

Hi, I'm working on building a data validation engine, which is supposed to check...

How to copy XML converted data to file on local drive?

By Jobs90312

Hi everyone, So I have been working on converting my SQL tables data into...

The Growth of IQP

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Growth of IQP

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers