Microsoft SQL Server
SQL Server Tutorial, Query's and Interview Questions
Friday 3 April 2015
List all schema names with table by SQL query?
SELECT
'['
+
SCHEMA_NAME
(
schema_id
)+
'].['
+
name
+
']'
AS
SchemaTable
FROM
sys
.
tables
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment