I used to list from sysobjects to get this information, but found the INFORMATION_SCHEMA is a lot easier.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2003-05-05

166 reads

Blogs

I set goals at the beginning of the year, and I’m tracking my progress...

Say you have a temp table and you want to see the columns names. For...

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

Read the latest Blogs

Forums

We are a team of 32 persons spread across the globe with supportive staff...

I am using SQL server 2008 R2 express edition. Out of below 3 method...

DBAs are being asked to know everything for 6 figures which cap out for...

Visit the forum

See possible answers