Tuesday, October 13, 2009

Finding a table name

I knew my table had "comment" in it... so I used this to find out the table name

SELECT name
FROM dbo.sysobjects
WHERE xtype = 'U' AND NAME LIKE '%COMMENT%'

I could also have used xtype:
'V' - views
'S' - system tables

From: http://database.ittoolbox.com/documents/finding-table-names-in-sql-18556 - thanks!

No comments:

Post a Comment