When I tried this query: <pre class="prettyprint"><code>sp_help '[OG_System].[dbo].[tbl_act]' </code></pre> This message appears: <blockquote> Msg 15250, Level 16, State 1, Procedure sp_help, Line 48 The database name component of the object qualifier must be the name of the current database. </blockquote>

Because your target database is different than current database. Use; <pre class="prettyprint"><code>EXEC [ServerName].[DatabaseName].dbo.sp_help 'tbl_act' </code></pre>

Table structure using sp

When I tried this query:

sp_help '[OG_System].[dbo].[tbl_act]'

This message appears:

Msg 15250, Level 16, State 1, Procedure sp_help, Line 48
The database name component of the object qualifier must be the name of the current database.

What does Sp_help do in SQL?

Reports information about a database object (any object listed in the sys. sysobjects compatibility view), a user-defined data type, or a data type.

How do you show the structure of a table?

So desc or describe command shows the structure of table which include name of the column, data-type of column and the nullability which means, that column can contain null values or not. All of these features of table are described at the time of Creation of table.

How can I show the table structure in SQL Server query?

To show table properties in the Properties window. In Object Explorer, select the table for which you want to show properties. Right-click the table and choose Properties from the shortcut menu. For more information, see Table Properties - SSMS.

Because your target database is different than current database.

Use;

EXEC [ServerName].[DatabaseName].dbo.sp_help 'tbl_act'

Table structure using sp_help

Tags:

sql

sql-server

ylleigh12

People also ask

1 Answers

goGud

Recent Activity

Donate For Us