SqlNotepad

[sqlnotepad-blog]

DECLARE VAR ------------------------------------------------------- DECLARE @tableName nvarchar(20) -------------------------------------------------------

-- INIT VAR ------------------------------------------------------- SET @db = 'DB_NAME_HERE' SET @tableName = 'TABLE_NAME_HERE' -------------------------------------------------------

SELECT TABLE_CATALOG 'Database' , TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE, COLUMN_DEFAULT FROM [INFORMATION_SCHEMA].[COLUMNS] WHERE TABLE_CATALOG = @db AND TABLE_NAME = @tableName ORDER BY ORDINAL_POSITION

[sqlnotepad-blog]

Table fields

SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = [THE_TABLE_NAME_HERE] ORDER BY TABLE_CATALOG, TABLE_NAME, ORDINAL_POSITION

[sqlnotepad-blog]

Table list in MS SQL database

USE  [DB_NAME]

SELECT NAME FROM Sys.tables ORDER BY NAME