Get full name of SQL Server tables

Question

Just some extract from the code:

cmd.CommandText = "SELECT TABLE_TYPE, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES";

using (dataReader = cmd.ExecuteReader())
{
     string tableName = (string)dataReader["TABLE_NAME"];
}

Should I use "table_schema" column of th INFORMATION_SCHEMA.TABLES like this:

dbo.string fullname = dataReader["table_schema"]+"."+dataReader["table_name"];

Or should I use another method? I need to insert this fullname in a script for insertion table data.

No need to downvote him. This is IMHO a fair question. In fact, he is asking for the schema information, but it seems he doesn't know the term. Upvote from my side, because this is a good question. — SQL Police
– SQL Police, Commented Nov 20, 2015 at 11:21

marc_s · Accepted Answer · 2015-11-20 11:16:41Z

3

Try something like this:

SELECT 
    SchemaName = s.Name,
    TableName = t.Name,
    FullName = s.Name + '.' + t.Name
FROM 
    sys.tables t
INNER JOIN 
    sys.schemas s ON s.schema_id = t.schema_id

This should give you the schema, the table name, and the combined (schema).(table name) notation

answered Nov 20, 2015 at 11:16

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get full name of SQL Server tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related