Getting list of tables, and fields in each, in a database

by

Is this what you are looking for:

Using OBJECT CATALOG VIEWS

 SELECT T.name AS Table_Name ,
       C.name AS Column_Name ,
       P.name AS Data_Type ,
       P.max_length AS Size ,
       CAST(P.precision AS VARCHAR) + "https://stackoverflow.com/" + CAST(P.scale AS VARCHAR) AS Precision_Scale
FROM   sys.objects AS T
       JOIN sys.columns AS C ON T.object_id = C.object_id
       JOIN sys.types AS P ON C.system_type_id = P.system_type_id
WHERE  T.type_desc="USER_TABLE";

Using INFORMATION SCHEMA VIEWS

  SELECT TABLE_SCHEMA ,
       TABLE_NAME ,
       COLUMN_NAME ,
       ORDINAL_POSITION ,
       COLUMN_DEFAULT ,
       DATA_TYPE ,
       CHARACTER_MAXIMUM_LENGTH ,
       NUMERIC_PRECISION ,
       NUMERIC_PRECISION_RADIX ,
       NUMERIC_SCALE ,
       DATETIME_PRECISION
FROM   INFORMATION_SCHEMA.COLUMNS;

Reference : My Blog – http://dbalink.wordpress.com/2008/10/24/querying-the-object-catalog-and-information-schema-views/

More Related Contents:

  1. SQL where clause odd behavior [closed]
  2. How do I escape a single quote in SQL Server?
  3. Simple way to transpose columns and rows in SQL?
  4. Count work days between two dates
  5. Only inserting a row if it’s not already there
  6. Unpivot with column name
  7. Selecting data from two different servers in SQL Server
  8. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  9. Most efficient way in SQL Server to get date from date+time?
  10. Convert varchar into datetime in SQL Server
  11. TSQL Pivot without aggregate function
  12. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  13. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  14. Convert Xml to Table SQL Server
  15. How do I create a foreign key in SQL Server?
  16. How do I group on continuous ranges
  17. join comma delimited data column
  18. Sql PIVOT and string concatenation aggregate
  19. Need to list all triggers in SQL Server database with table name and table’s schema
  20. Define variable to use with IN operator (T-SQL)
  21. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  22. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  23. Best equivalent for IsInteger in SQL Server
  24. Syntax of for-loop in SQL Server
  25. Comma separated values in a database field
  26. Grant SELECT permission on a view, but not on underlying objects
  27. SQL – Call Stored Procedure for each record
  28. COALESCE Function in TSQL
  29. Convert bigint to datetime
  30. Replacing NULL and empty string within Select statement

Leave a Comment