|
|
|
| MS SQL Server 2012 - DBA Articles |
DISCRIBE TABLE - Display Existing Table StructureThe sp_help system procedure is used to retrieves current database objects information. When name is not specified, sp_help lists object names, owners, and object types for all objects in the current database or else display specified object information. Example 01 Retrieve Database Objects Information The following example is used to display eBusiness database's objects information. -- Retrieve Database Objects Information --
USE eBusiness GO
sp_help Example 02 Retrieve Particular Object Information The following example is used to display eBusiness database's EMP object information. -- Retrieve Particular Object Information --
USE eBusiness GO
sp_help EMP |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR