How can I show the table structure in SQL Server query

Question

SELECT DateTime  Skill  Name  TimeZone  ID  User  Employee  Leader  FROM t Agent Skill Group Half Hour AS t   I need to view the table structure in a query

User · Answer

Another way is   mysql  gt  SHOW CREATE TABLE my db my table    You should get the table name and create table sql

User · Answer

To print a schema  I use jade and do an export to a file of the database then bring it into word to format and print

User · Answer

On SQL Server 2012  you can use the following stored procedure   sp columns   lt table name gt     For example  given a database table named users   sp columns  users

User · Answer

Try this query   DECLARE  table name SYSNAME SELECT  table name    dbo test table   DECLARE         object name SYSNAME        object id INT  SELECT         object name         s name           o name              object id   o  object id  FROM sys objects o WITH  NOWAIT  JOIN sys schemas s WITH  NOWAIT  ON o  schema id    s  schema id  WHERE s name         o name    table name     AND o  type     U      AND o is ms shipped   0  DECLARE  SQL NVARCHAR MAX         WITH index column AS        SELECT            ic  object id            ic index id           ic is descending key           ic is included column           c name     FROM sys index columns ic WITH  NOWAIT      JOIN sys columns c WITH  NOWAIT  ON ic  object id    c  object id  AND ic column id   c column id     WHERE ic  object id     object id   SELECT  SQL    CREATE TABLE      object name   CHAR 13          CHAR 13    STUFF       SELECT CHAR 9            c name                   CASE WHEN c is computed   1             THEN  AS     cc  definition               ELSE UPPER tp name                     CASE WHEN tp name IN   varchar    char    varbinary    binary    text                          THEN       CASE WHEN c max length   -1 THEN  MAX  ELSE CAST c max length AS VARCHAR 5   END                            WHEN tp name IN   nvarchar    nchar    ntext                          THEN       CASE WHEN c max length   -1 THEN  MAX  ELSE CAST c max length   2 AS VARCHAR 5   END                            WHEN tp name IN   datetime2    time2    datetimeoffset                           THEN       CAST c scale AS VARCHAR 5                              WHEN tp name    decimal                          THEN       CAST c  precision  AS VARCHAR 5           CAST c scale AS VARCHAR 5                             ELSE                    END                   CASE WHEN c collation name IS NOT NULL THEN   COLLATE     c collation name ELSE    END                   CASE WHEN c is nullable   1 THEN   NULL  ELSE   NOT NULL  END                   CASE WHEN dc  definition  IS NOT NULL THEN   DEFAULT    dc  definition  ELSE    END                    CASE WHEN ic is identity   1 THEN   IDENTITY     CAST ISNULL ic seed value   0   AS CHAR 1           CAST ISNULL ic increment value   1   AS CHAR 1         ELSE    END          END   CHAR 13      FROM sys columns c WITH  NOWAIT      JOIN sys types tp WITH  NOWAIT  ON c user type id   tp user type id     LEFT JOIN sys computed columns cc WITH  NOWAIT  ON c  object id    cc  object id  AND c column id   cc column id     LEFT JOIN sys default constraints dc WITH  NOWAIT  ON c default object id    0 AND c  object id    dc parent object id AND c column id   dc parent column id     LEFT JOIN sys identity columns ic WITH  NOWAIT  ON c is identity   1 AND c  object id    ic  object id  AND c column id   ic column id     WHERE c  object id     object id     ORDER BY c column id     FOR XML PATH      TYPE  value       NVARCHAR MAX     1  2  CHAR 9               ISNULL  SELECT CHAR 9       CONSTRAINT      k name      PRIMARY KEY                            SELECT STUFF                            SELECT         c name          CASE WHEN ic is descending key   1 THEN  DESC  ELSE  ASC  END                          FROM sys index columns ic WITH  NOWAIT                           JOIN sys columns c WITH  NOWAIT  ON c  object id    ic  object id  AND c column id   ic column id                          WHERE ic is included column   0                              AND ic  object id    k parent object id                               AND ic index id   k unique index id                               FOR XML PATH N     TYPE  value       NVARCHAR MAX     1  2                           CHAR 13              FROM sys key constraints k WITH  NOWAIT              WHERE k parent object id    object id                  AND k  type     PK                 CHAR 13   PRINT  SQL   Output   CREATE TABLE  dbo   test table           WorkOutID  BIGINT NOT NULL IDENTITY 1 1         DateOut  DATETIME NOT NULL        EmployeeID  INT NOT NULL        IsMainWorkPlace  BIT NOT NULL DEFAULT  1          WorkPlaceUID  UNIQUEIDENTIFIER NULL        WorkShiftCD  NVARCHAR 10  COLLATE Cyrillic General CI AS NULL        CategoryID  INT NULL       CONSTRAINT  PK WorkOut  PRIMARY KEY   WorkOutID  ASC      Also read this   http   www c-sharpcorner com UploadFile 67b45a how-to-generate-a-create-table-script-for-an-existing-table

User · Answer

In SQL Server  you can use this query  USE Database name  SELECT   FROM INFORMATION SCHEMA COLUMNS WHERE TABLE NAME  Table Name    And do not forget to replace Database name and Table name with the exact names of your database and table names

User · Answer

I was trying  DESC table name  but then this worked for me in psql   select    from INFORMATION SCHEMA COLUMNS where TABLE NAME  table name

User · Answer

For SQL Server  if using a newer version  you can use  select   from INFORMATION SCHEMA COLUMNS where TABLE NAME  tableName    There are different ways to get the schema  Using ADO NET  you can use the schema methods  Use the DbConnection s GetSchema method or the DataReader sGetSchemaTable method   Provided that you have a reader for the for the query  you can do something like this   using DbCommand cmd        using var reader   cmd ExecuteReader          var schema   reader GetSchemaTable        foreach DataRow row in schema Rows                Debug WriteLine row  ColumnName       -     row  DataTypeName              See this article for further details

User · Answer

For recent versions of SQL Server Management Studio Write the  in a query editor and Do  Alt     F1

User · Answer

sp help tablename in sql server  desc tablename in oracle

[sql-server] How can I show the table structure in SQL Server query?

Examples related to sql-server