Technical Article

List Table Definition

System Stored Procedure to List the Table Definition of a table as a printable report. The procedure must exist in the master database. This works for any table in the current database. Do not fully qualify the tablename. Calling sample: use pubs exec sp_listtabledef 'authors'

3 (3)

2001-12-18

3,369 reads

Blogs

A Few Thoughts on SQL Saturday Jacksonville

By

I was lucky to attend SQSQL Saturday Jacksonville 2022L Saturday Jacksonville 2022 a couple...

Techorama 2022 – Session Materials

By

You can find my slidedeck for the session “Introduction to Azure Data Factory” on...

Daily Coping 24 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Indexing

By bobrooney.81

Hi All, How to tell if the index is useful for my reads or...

Logging sql stms into a table when there is a High cpu alert

By bobrooney.81

Hi, Whenever I get an high cpu alert , be it non-working hours or...

Transactions names meaning In Transaction Logs

By IT researcher

I am using .LDF file to get the information about when was DB last...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers