Microsoft SQL Server
SQL Server Tutorial, Query's and Interview Questions
Showing posts with label
List all schema names with table by SQL query?
.
Show all posts
Showing posts with label
List all schema names with table by SQL query?
.
Show all posts
Friday, 3 April 2015
List all schema names with table by SQL query?
SELECT
'['
+
SCHEMA_NAME
(
schema_id
)+
'].['
+
name
+
']'
AS
SchemaTable
FROM
sys
.
tables
Older Posts
Home
Subscribe to:
Posts (Atom)