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

130 reads

Blogs

Migrating SSIS to Azure – Slidedeck (Techorama 2019)

By

Techorama 2019 is over and it was a blast, as usual. Neatly organised, great...

Containers: Create a Custom Container

By

Creating a custom container is where things get truly exciting. There’s actually a ton...

Mini-Rant: Spoofed Phone Numbers and Trust

By

I’ve seen this more and more over the last year: I receive a phone...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Function Issues

By MattNorman88

I have created the following function which is to be used for a check...

SQL Server health check

By 892717952

If I want to do a SQL Server health check, which aspects should be...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers