Microsoft SQL Server
SQL Server Tutorial, Query's and Interview Questions
Friday, 3 April 2015
How to list all the tables in SQL Server for particular Schema.?
SELECT
t
.
name
FROM
sys
.
tables
AS
t
INNER
JOIN
sys
.
schemas
AS
sON t
.
[schema_id]
=
s
.
[schema_id]
WHERE
s
.
name
=
'sales'
;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment