List names of all tables in a SQL Server 2012 schema

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

I have a schema in SQL Server 2012.

Is there a command that I can run in SQL to get the names of all the tables in that schema that were populated by user?

I know a similar query for MySQL SHOW TABLES; but this does not work with SQL Server.

edited Jan 21 '15 at 19:51

acdcjunior

83.3k22195194

asked Jan 23 '14 at 15:21

AnkitGarg43

308137

What does "populated by user" mean? Its very ambiguous in this context.

– RBarryYoung
Jan 23 '14 at 15:44

possible duplicate of SQL statement to grab table names, views, and stored procs, order by schema

– Charles Burns
Jan 23 '14 at 15:52

What I meant by that was, some tables are created by the system and some are created by the code written and executed by the program for which the user is using the database. Sorry for being ambiguous. But I found the solution for my problem.

– AnkitGarg43
Jan 23 '14 at 15:52

add a comment |

I have a schema in SQL Server 2012.

Is there a command that I can run in SQL to get the names of all the tables in that schema that were populated by user?

I know a similar query for MySQL SHOW TABLES; but this does not work with SQL Server.

edited Jan 21 '15 at 19:51

acdcjunior

83.3k22195194

asked Jan 23 '14 at 15:21

AnkitGarg43

308137

What does "populated by user" mean? Its very ambiguous in this context.

– RBarryYoung
Jan 23 '14 at 15:44

possible duplicate of SQL statement to grab table names, views, and stored procs, order by schema

– Charles Burns
Jan 23 '14 at 15:52

What I meant by that was, some tables are created by the system and some are created by the code written and executed by the program for which the user is using the database. Sorry for being ambiguous. But I found the solution for my problem.

– AnkitGarg43
Jan 23 '14 at 15:52

add a comment |

I have a schema in SQL Server 2012.

Is there a command that I can run in SQL to get the names of all the tables in that schema that were populated by user?

I know a similar query for MySQL SHOW TABLES; but this does not work with SQL Server.

edited Jan 21 '15 at 19:51

acdcjunior

83.3k22195194

asked Jan 23 '14 at 15:21

AnkitGarg43

308137

I have a schema in SQL Server 2012.

Is there a command that I can run in SQL to get the names of all the tables in that schema that were populated by user?

I know a similar query for MySQL SHOW TABLES; but this does not work with SQL Server.

sql sql-server

edited Jan 21 '15 at 19:51

acdcjunior

83.3k22195194

asked Jan 23 '14 at 15:21

AnkitGarg43

308137

edited Jan 21 '15 at 19:51

acdcjunior

83.3k22195194

asked Jan 23 '14 at 15:21

AnkitGarg43

308137

edited Jan 21 '15 at 19:51

acdcjunior

83.3k22195194

edited Jan 21 '15 at 19:51

acdcjunior

83.3k22195194

edited Jan 21 '15 at 19:51

acdcjunior

83.3k22195194

asked Jan 23 '14 at 15:21

AnkitGarg43

308137

asked Jan 23 '14 at 15:21

AnkitGarg43

308137

asked Jan 23 '14 at 15:21

AnkitGarg43

308137

What does "populated by user" mean? Its very ambiguous in this context.

– RBarryYoung
Jan 23 '14 at 15:44

possible duplicate of SQL statement to grab table names, views, and stored procs, order by schema

– Charles Burns
Jan 23 '14 at 15:52

What I meant by that was, some tables are created by the system and some are created by the code written and executed by the program for which the user is using the database. Sorry for being ambiguous. But I found the solution for my problem.

– AnkitGarg43
Jan 23 '14 at 15:52

add a comment |

What does "populated by user" mean? Its very ambiguous in this context.

– RBarryYoung
Jan 23 '14 at 15:44

possible duplicate of SQL statement to grab table names, views, and stored procs, order by schema

– Charles Burns
Jan 23 '14 at 15:52

What I meant by that was, some tables are created by the system and some are created by the code written and executed by the program for which the user is using the database. Sorry for being ambiguous. But I found the solution for my problem.

– AnkitGarg43
Jan 23 '14 at 15:52

What does "populated by user" mean? Its very ambiguous in this context.

– RBarryYoung
Jan 23 '14 at 15:44

possible duplicate of SQL statement to grab table names, views, and stored procs, order by schema

– Charles Burns
Jan 23 '14 at 15:52

What I meant by that was, some tables are created by the system and some are created by the code written and executed by the program for which the user is using the database. Sorry for being ambiguous. But I found the solution for my problem.

– AnkitGarg43
Jan 23 '14 at 15:52

add a comment |

6 Answers
6

active

oldest

votes

Your should really use the INFORMATION_SCHEMA views in your database:

USE <your_database_name>
GO
SELECT * FROM INFORMATION_SCHEMA.TABLES

You can then filter that by table schema and/or table type, e.g.

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

answered Jan 23 '14 at 15:28

Kev

98.3k45266356

2

Meh, while standard and portable, I recommend against INFORMATION_SCHEMA, mostly because they're incomplete: sqlblog.com/blogs/aaron_bertrand/archive/2011/11/03/…

– Aaron Bertrand
Jan 23 '14 at 15:30

@AaronBertrand - you have a point, I use them up to the point I can't, then spelunk the system tables.

– Kev
Jan 23 '14 at 15:34

see and I don't see the point of that. Why use something when inevitably you'll need to switch gears? If you start with the catalog views, you don't have to change tactics when you come across something that INFORMATION_SCHEMA doesn't bother to cover. Kind of like having a cheese allergy, but eating cheese until it makes you sick. I'd rather just pretend that cheese (and INFORMATION_SCHEMA) doesn't exist.

– Aaron Bertrand
Jan 23 '14 at 15:35

add a comment |

SELECT t.name 
 FROM sys.tables AS t
 INNER JOIN sys.schemas AS s
 ON t.[schema_id] = s.[schema_id]
 WHERE s.name = N'schema_name';

answered Jan 23 '14 at 15:23

Aaron Bertrand

213k27372410

This does not limit to tables 'populated by user'.

– jtimperley
Jan 23 '14 at 15:27

@jtimperley Well, I assumed "populated by user" was in reference to tables created by a user using a specific schema. In any case, what system tables do you see returned by this query? If you enable diagram support, is_ms_shipped is 0 for sysdiagrams, so your filter doesn't exclude it either.

– Aaron Bertrand
Jan 23 '14 at 15:27

(Not that sysdiagrams or any other system tables added, e.g. systranschemas which is created when CDC support is added, would match any schema other than dbo anyway.)

– Aaron Bertrand
Jan 23 '14 at 15:33

add a comment |

SQL Server 2005, 2008, 2012 or 2014:

SELECT * FROM information_schema.tables WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA = 'dbo'

For more details:
How do I get list of all tables in a database using TSQL?

edited May 23 '17 at 11:46

Community♦

answered Oct 27 '16 at 1:14

Nandoviski

155111

add a comment |

SELECT t1.name AS [Schema], t2.name AS [Table]
FROM sys.schemas t1
INNER JOIN sys.tables t2
ON t2.schema_id = t1.schema_id
ORDER BY t1.name,t2.name

answered Jul 10 '17 at 20:50

Lorena Pita

697814

add a comment |

SELECT *
FROM sys.tables t
INNER JOIN sys.objects o on o.object_id = t.object_id
WHERE o.is_ms_shipped = 0;

answered Jan 23 '14 at 15:23

jtimperley

2,26479

You should be able to run it just like that but you're free to make whatever changed needed. :) Filter outputted columns, add extra filters, derive table sizes, whatever.

– jtimperley
Jan 23 '14 at 15:25

This does not limit the results to a specific schema.

– Aaron Bertrand
Jan 23 '14 at 15:25

add a comment |

select * from [schema_name].sys.tables

This should work. Make sure you are on the server which consists of your "[schema_name]"

edited Nov 15 '18 at 12:11

suvojit_007

1,3372618

answered Nov 15 '18 at 11:27

Saman Kapali

add a comment |

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f21312331%2flist-names-of-all-tables-in-a-sql-server-2012-schema%23new-answer', 'question_page');

);

Post as a guest

Name

Required, but never shown

6 Answers
6

active

oldest

votes

6 Answers
6

active

oldest

votes

Your should really use the INFORMATION_SCHEMA views in your database:

USE <your_database_name>
GO
SELECT * FROM INFORMATION_SCHEMA.TABLES

You can then filter that by table schema and/or table type, e.g.

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

answered Jan 23 '14 at 15:28

Kev

98.3k45266356

2

Meh, while standard and portable, I recommend against INFORMATION_SCHEMA, mostly because they're incomplete: sqlblog.com/blogs/aaron_bertrand/archive/2011/11/03/…

– Aaron Bertrand
Jan 23 '14 at 15:30

@AaronBertrand - you have a point, I use them up to the point I can't, then spelunk the system tables.

– Kev
Jan 23 '14 at 15:34

see and I don't see the point of that. Why use something when inevitably you'll need to switch gears? If you start with the catalog views, you don't have to change tactics when you come across something that INFORMATION_SCHEMA doesn't bother to cover. Kind of like having a cheese allergy, but eating cheese until it makes you sick. I'd rather just pretend that cheese (and INFORMATION_SCHEMA) doesn't exist.

– Aaron Bertrand
Jan 23 '14 at 15:35

add a comment |

Your should really use the INFORMATION_SCHEMA views in your database:

USE <your_database_name>
GO
SELECT * FROM INFORMATION_SCHEMA.TABLES

You can then filter that by table schema and/or table type, e.g.

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

answered Jan 23 '14 at 15:28

Kev

98.3k45266356

2

Meh, while standard and portable, I recommend against INFORMATION_SCHEMA, mostly because they're incomplete: sqlblog.com/blogs/aaron_bertrand/archive/2011/11/03/…

– Aaron Bertrand
Jan 23 '14 at 15:30

@AaronBertrand - you have a point, I use them up to the point I can't, then spelunk the system tables.

– Kev
Jan 23 '14 at 15:34

see and I don't see the point of that. Why use something when inevitably you'll need to switch gears? If you start with the catalog views, you don't have to change tactics when you come across something that INFORMATION_SCHEMA doesn't bother to cover. Kind of like having a cheese allergy, but eating cheese until it makes you sick. I'd rather just pretend that cheese (and INFORMATION_SCHEMA) doesn't exist.

– Aaron Bertrand
Jan 23 '14 at 15:35

add a comment |

Your should really use the INFORMATION_SCHEMA views in your database:

USE <your_database_name>
GO
SELECT * FROM INFORMATION_SCHEMA.TABLES

You can then filter that by table schema and/or table type, e.g.

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

answered Jan 23 '14 at 15:28

Kev

98.3k45266356

Your should really use the INFORMATION_SCHEMA views in your database:

USE <your_database_name>
GO
SELECT * FROM INFORMATION_SCHEMA.TABLES

You can then filter that by table schema and/or table type, e.g.

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'

answered Jan 23 '14 at 15:28

Kev

98.3k45266356

answered Jan 23 '14 at 15:28

Kev

98.3k45266356

answered Jan 23 '14 at 15:28

Kev

98.3k45266356

answered Jan 23 '14 at 15:28

Kev

98.3k45266356

2

Meh, while standard and portable, I recommend against INFORMATION_SCHEMA, mostly because they're incomplete: sqlblog.com/blogs/aaron_bertrand/archive/2011/11/03/…

– Aaron Bertrand
Jan 23 '14 at 15:30

@AaronBertrand - you have a point, I use them up to the point I can't, then spelunk the system tables.

– Kev
Jan 23 '14 at 15:34

see and I don't see the point of that. Why use something when inevitably you'll need to switch gears? If you start with the catalog views, you don't have to change tactics when you come across something that INFORMATION_SCHEMA doesn't bother to cover. Kind of like having a cheese allergy, but eating cheese until it makes you sick. I'd rather just pretend that cheese (and INFORMATION_SCHEMA) doesn't exist.

– Aaron Bertrand
Jan 23 '14 at 15:35

add a comment |

2

Meh, while standard and portable, I recommend against INFORMATION_SCHEMA, mostly because they're incomplete: sqlblog.com/blogs/aaron_bertrand/archive/2011/11/03/…

– Aaron Bertrand
Jan 23 '14 at 15:30

@AaronBertrand - you have a point, I use them up to the point I can't, then spelunk the system tables.

– Kev
Jan 23 '14 at 15:34

see and I don't see the point of that. Why use something when inevitably you'll need to switch gears? If you start with the catalog views, you don't have to change tactics when you come across something that INFORMATION_SCHEMA doesn't bother to cover. Kind of like having a cheese allergy, but eating cheese until it makes you sick. I'd rather just pretend that cheese (and INFORMATION_SCHEMA) doesn't exist.

– Aaron Bertrand
Jan 23 '14 at 15:35

Meh, while standard and portable, I recommend against INFORMATION_SCHEMA, mostly because they're incomplete: sqlblog.com/blogs/aaron_bertrand/archive/2011/11/03/…

– Aaron Bertrand
Jan 23 '14 at 15:30

@AaronBertrand - you have a point, I use them up to the point I can't, then spelunk the system tables.

– Kev
Jan 23 '14 at 15:34

see and I don't see the point of that. Why use something when inevitably you'll need to switch gears? If you start with the catalog views, you don't have to change tactics when you come across something that INFORMATION_SCHEMA doesn't bother to cover. Kind of like having a cheese allergy, but eating cheese until it makes you sick. I'd rather just pretend that cheese (and INFORMATION_SCHEMA) doesn't exist.

– Aaron Bertrand
Jan 23 '14 at 15:35

add a comment |

SELECT t.name 
 FROM sys.tables AS t
 INNER JOIN sys.schemas AS s
 ON t.[schema_id] = s.[schema_id]
 WHERE s.name = N'schema_name';

answered Jan 23 '14 at 15:23

Aaron Bertrand

213k27372410

This does not limit to tables 'populated by user'.

– jtimperley
Jan 23 '14 at 15:27

@jtimperley Well, I assumed "populated by user" was in reference to tables created by a user using a specific schema. In any case, what system tables do you see returned by this query? If you enable diagram support, is_ms_shipped is 0 for sysdiagrams, so your filter doesn't exclude it either.

– Aaron Bertrand
Jan 23 '14 at 15:27

(Not that sysdiagrams or any other system tables added, e.g. systranschemas which is created when CDC support is added, would match any schema other than dbo anyway.)

– Aaron Bertrand
Jan 23 '14 at 15:33

add a comment |

SELECT t.name 
 FROM sys.tables AS t
 INNER JOIN sys.schemas AS s
 ON t.[schema_id] = s.[schema_id]
 WHERE s.name = N'schema_name';

answered Jan 23 '14 at 15:23

Aaron Bertrand

213k27372410

This does not limit to tables 'populated by user'.

– jtimperley
Jan 23 '14 at 15:27

@jtimperley Well, I assumed "populated by user" was in reference to tables created by a user using a specific schema. In any case, what system tables do you see returned by this query? If you enable diagram support, is_ms_shipped is 0 for sysdiagrams, so your filter doesn't exclude it either.

– Aaron Bertrand
Jan 23 '14 at 15:27

(Not that sysdiagrams or any other system tables added, e.g. systranschemas which is created when CDC support is added, would match any schema other than dbo anyway.)

– Aaron Bertrand
Jan 23 '14 at 15:33

add a comment |

SELECT t.name 
 FROM sys.tables AS t
 INNER JOIN sys.schemas AS s
 ON t.[schema_id] = s.[schema_id]
 WHERE s.name = N'schema_name';

answered Jan 23 '14 at 15:23

Aaron Bertrand

213k27372410

SELECT t.name 
 FROM sys.tables AS t
 INNER JOIN sys.schemas AS s
 ON t.[schema_id] = s.[schema_id]
 WHERE s.name = N'schema_name';

answered Jan 23 '14 at 15:23

Aaron Bertrand

213k27372410

answered Jan 23 '14 at 15:23

Aaron Bertrand

213k27372410

answered Jan 23 '14 at 15:23

Aaron Bertrand

213k27372410

answered Jan 23 '14 at 15:23

Aaron Bertrand

213k27372410

This does not limit to tables 'populated by user'.

– jtimperley
Jan 23 '14 at 15:27

@jtimperley Well, I assumed "populated by user" was in reference to tables created by a user using a specific schema. In any case, what system tables do you see returned by this query? If you enable diagram support, is_ms_shipped is 0 for sysdiagrams, so your filter doesn't exclude it either.

– Aaron Bertrand
Jan 23 '14 at 15:27

(Not that sysdiagrams or any other system tables added, e.g. systranschemas which is created when CDC support is added, would match any schema other than dbo anyway.)

– Aaron Bertrand
Jan 23 '14 at 15:33

add a comment |

This does not limit to tables 'populated by user'.

– jtimperley
Jan 23 '14 at 15:27

@jtimperley Well, I assumed "populated by user" was in reference to tables created by a user using a specific schema. In any case, what system tables do you see returned by this query? If you enable diagram support, is_ms_shipped is 0 for sysdiagrams, so your filter doesn't exclude it either.

– Aaron Bertrand
Jan 23 '14 at 15:27

(Not that sysdiagrams or any other system tables added, e.g. systranschemas which is created when CDC support is added, would match any schema other than dbo anyway.)

– Aaron Bertrand
Jan 23 '14 at 15:33

This does not limit to tables 'populated by user'.

– jtimperley
Jan 23 '14 at 15:27

@jtimperley Well, I assumed "populated by user" was in reference to tables created by a user using a specific schema. In any case, what system tables do you see returned by this query? If you enable diagram support, is_ms_shipped is 0 for sysdiagrams, so your filter doesn't exclude it either.

– Aaron Bertrand
Jan 23 '14 at 15:27

(Not that sysdiagrams or any other system tables added, e.g. systranschemas which is created when CDC support is added, would match any schema other than dbo anyway.)

– Aaron Bertrand
Jan 23 '14 at 15:33

add a comment |

SQL Server 2005, 2008, 2012 or 2014:

SELECT * FROM information_schema.tables WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA = 'dbo'

For more details:
How do I get list of all tables in a database using TSQL?

edited May 23 '17 at 11:46

Community♦

answered Oct 27 '16 at 1:14

Nandoviski

155111

add a comment |

SQL Server 2005, 2008, 2012 or 2014:

SELECT * FROM information_schema.tables WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA = 'dbo'

For more details:
How do I get list of all tables in a database using TSQL?

edited May 23 '17 at 11:46

Community♦

answered Oct 27 '16 at 1:14

Nandoviski

155111

add a comment |

SQL Server 2005, 2008, 2012 or 2014:

SELECT * FROM information_schema.tables WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA = 'dbo'

For more details:
How do I get list of all tables in a database using TSQL?

edited May 23 '17 at 11:46

Community♦

answered Oct 27 '16 at 1:14

Nandoviski

155111

SQL Server 2005, 2008, 2012 or 2014:

SELECT * FROM information_schema.tables WHERE TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA = 'dbo'

For more details:
How do I get list of all tables in a database using TSQL?

edited May 23 '17 at 11:46

Community♦

answered Oct 27 '16 at 1:14

Nandoviski

155111

edited May 23 '17 at 11:46

Community♦

edited May 23 '17 at 11:46

Community♦

edited May 23 '17 at 11:46

Community♦

answered Oct 27 '16 at 1:14

Nandoviski

155111

answered Oct 27 '16 at 1:14

Nandoviski

155111

answered Oct 27 '16 at 1:14

Nandoviski

155111

add a comment |

SELECT t1.name AS [Schema], t2.name AS [Table]
FROM sys.schemas t1
INNER JOIN sys.tables t2
ON t2.schema_id = t1.schema_id
ORDER BY t1.name,t2.name

answered Jul 10 '17 at 20:50

Lorena Pita

697814

add a comment |

SELECT t1.name AS [Schema], t2.name AS [Table]
FROM sys.schemas t1
INNER JOIN sys.tables t2
ON t2.schema_id = t1.schema_id
ORDER BY t1.name,t2.name

answered Jul 10 '17 at 20:50

Lorena Pita

697814

add a comment |

SELECT t1.name AS [Schema], t2.name AS [Table]
FROM sys.schemas t1
INNER JOIN sys.tables t2
ON t2.schema_id = t1.schema_id
ORDER BY t1.name,t2.name

answered Jul 10 '17 at 20:50

Lorena Pita

697814

SELECT t1.name AS [Schema], t2.name AS [Table]
FROM sys.schemas t1
INNER JOIN sys.tables t2
ON t2.schema_id = t1.schema_id
ORDER BY t1.name,t2.name

answered Jul 10 '17 at 20:50

Lorena Pita

697814

answered Jul 10 '17 at 20:50

Lorena Pita

697814

answered Jul 10 '17 at 20:50

Lorena Pita

697814

answered Jul 10 '17 at 20:50

Lorena Pita

697814

add a comment |

SELECT *
FROM sys.tables t
INNER JOIN sys.objects o on o.object_id = t.object_id
WHERE o.is_ms_shipped = 0;

answered Jan 23 '14 at 15:23

jtimperley

2,26479

You should be able to run it just like that but you're free to make whatever changed needed. :) Filter outputted columns, add extra filters, derive table sizes, whatever.

– jtimperley
Jan 23 '14 at 15:25

This does not limit the results to a specific schema.

– Aaron Bertrand
Jan 23 '14 at 15:25

add a comment |

SELECT *
FROM sys.tables t
INNER JOIN sys.objects o on o.object_id = t.object_id
WHERE o.is_ms_shipped = 0;

answered Jan 23 '14 at 15:23

jtimperley

2,26479

You should be able to run it just like that but you're free to make whatever changed needed. :) Filter outputted columns, add extra filters, derive table sizes, whatever.

– jtimperley
Jan 23 '14 at 15:25

This does not limit the results to a specific schema.

– Aaron Bertrand
Jan 23 '14 at 15:25

add a comment |

SELECT *
FROM sys.tables t
INNER JOIN sys.objects o on o.object_id = t.object_id
WHERE o.is_ms_shipped = 0;

answered Jan 23 '14 at 15:23

jtimperley

2,26479

SELECT *
FROM sys.tables t
INNER JOIN sys.objects o on o.object_id = t.object_id
WHERE o.is_ms_shipped = 0;

answered Jan 23 '14 at 15:23

jtimperley

2,26479

answered Jan 23 '14 at 15:23

jtimperley

2,26479

answered Jan 23 '14 at 15:23

jtimperley

2,26479

answered Jan 23 '14 at 15:23

jtimperley

2,26479

You should be able to run it just like that but you're free to make whatever changed needed. :) Filter outputted columns, add extra filters, derive table sizes, whatever.

– jtimperley
Jan 23 '14 at 15:25

This does not limit the results to a specific schema.

– Aaron Bertrand
Jan 23 '14 at 15:25

add a comment |

You should be able to run it just like that but you're free to make whatever changed needed. :) Filter outputted columns, add extra filters, derive table sizes, whatever.

– jtimperley
Jan 23 '14 at 15:25

This does not limit the results to a specific schema.

– Aaron Bertrand
Jan 23 '14 at 15:25

You should be able to run it just like that but you're free to make whatever changed needed. :) Filter outputted columns, add extra filters, derive table sizes, whatever.

– jtimperley
Jan 23 '14 at 15:25

This does not limit the results to a specific schema.

– Aaron Bertrand
Jan 23 '14 at 15:25

add a comment |

select * from [schema_name].sys.tables

This should work. Make sure you are on the server which consists of your "[schema_name]"

edited Nov 15 '18 at 12:11

suvojit_007

1,3372618

answered Nov 15 '18 at 11:27

Saman Kapali

add a comment |

select * from [schema_name].sys.tables

This should work. Make sure you are on the server which consists of your "[schema_name]"

edited Nov 15 '18 at 12:11

suvojit_007

1,3372618

answered Nov 15 '18 at 11:27

Saman Kapali

add a comment |

select * from [schema_name].sys.tables

This should work. Make sure you are on the server which consists of your "[schema_name]"

edited Nov 15 '18 at 12:11

suvojit_007

1,3372618

answered Nov 15 '18 at 11:27

Saman Kapali

select * from [schema_name].sys.tables

This should work. Make sure you are on the server which consists of your "[schema_name]"

edited Nov 15 '18 at 12:11

suvojit_007

1,3372618

answered Nov 15 '18 at 11:27

Saman Kapali

edited Nov 15 '18 at 12:11

suvojit_007

1,3372618

edited Nov 15 '18 at 12:11

suvojit_007

1,3372618

edited Nov 15 '18 at 12:11

suvojit_007

1,3372618

answered Nov 15 '18 at 11:27

Saman Kapali

answered Nov 15 '18 at 11:27

Saman Kapali

answered Nov 15 '18 at 11:27

Saman Kapali

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

搜尋此網誌

Pfthb