T-SQL query to show table definition?

by

There is no easy way to return the DDL. However you can get most of the details from Information Schema Views and System Views.

SELECT ORDINAL_POSITION, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
       , IS_NULLABLE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'Customers'

SELECT CONSTRAINT_NAME
FROM INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
WHERE TABLE_NAME = 'Customers'

SELECT name, type_desc, is_unique, is_primary_key
FROM sys.indexes
WHERE [object_id] = OBJECT_ID('dbo.Customers')

More Related Contents:

  1. SQL Server – error when creating stored procedure
  2. How can foreign key constraints be temporarily disabled using T-SQL?
  3. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  4. How can I escape square brackets in a LIKE clause?
  5. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  6. Parameter Sniffing (or Spoofing) in SQL Server
  7. SQL Server String or binary data would be truncated
  8. Datatype for storing ip address in SQL Server
  9. How to change identity column values programmatically?
  10. SQL Server Regular expressions in T-SQL
  11. Is there a way to loop through a table variable in TSQL without using a cursor?
  12. Maximum size of a varchar(max) variable
  13. best way to convert and validate a date string
  14. Concatenating Column Values into a Comma-Separated List
  15. Is there a way to simplify a NULL compare of 2 values
  16. TSQL Try / Catch within Transaction or vice versa?
  17. What is the maximum number of characters that nvarchar(MAX) will hold?
  18. TSQL: Create a view that accesses multiple databases
  19. Sequence as default value for a column
  20. Aggregate bitwise-OR in a subquery
  21. How do I flush the PRINT buffer in TSQL?
  22. OR Operator Short-circuit in SQL Server
  23. How to change default language for SQL Server?
  24. T-SQL incrementing counter based on change in a column value
  25. Cannot bulk load. Operating system error code 5 (Access is denied.)
  26. comparing a column to a list of values in t-sql
  27. Does query plan optimizer works well with joined/filtered table-valued functions?
  28. How to set value to variable using ‘execute’ in t-sql?
  29. Update SQL with consecutive numbering
  30. Count number of records returned by group by

Leave a Comment