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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2003-05-05

173 reads

Blogs

SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...

If it fails where you thought it would fail that is not a failure....

Quite a long title for a short blog post ??While deploying a DACPAC (from...

Forums

Comments posted to this topic are about the item Don't Create Workslop

Comments posted to this topic are about the item What is the original database...

Comments posted to this topic are about the item The DBScan algorithm tutorial

What is returned when this code is run?

SELECT ORIGINAL_DB_NAME()