NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

Blog > SQL Tools > Template Scripts > Table > Tables List

Template Script: Table\Tables List.sql

-- object list
SELECT  sc.Name AS SchemaName,
        ob.name AS ObjectName,
        '[' + sc.Name + '].[' + ob.name + ']' AS FullName,
        ob.type,
        ob.type_desc,
        ob.OBJECT_ID
FROM    sys.objects ob (NOLOCK)
INNER JOIN sys.schemas sc (NOLOCK) ON ob.SCHEMA_ID = sc.SCHEMA_ID
WHERE   ob.type = 'U'
        AND sc.name = 'tTax'
        AND ob.name = 'Property'
ORDER BY sc.name,
        ob.name

Description for Template Script: Table\Tables List.sql

Todo