SqlNotepad @sqlnotepad-blog - Tumblr 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

•18+ Adults Only

Watch Anya Live on Cam

Anya is live and ready to show you everything. Watch her strip, dance, and perform exclusive shows just for you. Interact in real-time and make your fantasies come true.

✓ Live Streaming✓ Interactive Chat✓ Private Shows✓ HD Quality

Anya is LIVE right now

FREE

Free to watch • No registration required • HD streaming

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

#table fields #ms sql #sql #SQL Tips

Table list in MS SQL database

USE [DB_NAME]

SELECT NAME FROM Sys.tables ORDER BY NAME

#SQl Tips #Table name

Trending Blogs

Last Seen Blogs

SqlNotepad