>I am trying to create a DB design document for a legacy DB. Part of this is the row count of each table. I have put together the following query, but it chokes at the line indicated (inside the cursor).
>
> Msg 1087, Level 15, State 2, Line 44
> Must declare the table variable "@TableName".
>
>All help is always appreciated.
>
>Line of error:
>

>  	SET @RowCount = (SELECT COUNT (*) FROM @TableName)
>

>
>Whole code:
>

>USE MyDB
>GO
>DECLARE @TableName	VARCHAR(256),
>		@RowCount	INT
>
>DROP TABLE [dbo].[#MyDBTableInfo]
>
>CREATE TABLE #MyDBTableInfo (
>	MyDBTableInfoID			INT IDENTITY (1,1) PRIMARY KEY,
>	TableName					VARCHAR(256),
>	TableRowCount				SMALLINT,
>	COLUMN_NAME					VARCHAR(128),
>	ORDINAL_POSITION			INT,
>	COLUMN_DEFAULT				VARCHAR(4000),
>	DATA_TYPE					VARCHAR(128),
>	CHARACTER_MAXIMUM_LENGTH	INT,
>	NUMERIC_PRECISION			INT,
>	NUMERIC_PRECISION_RADIX		SMALLINT,
>	NUMERIC_SCALE				INT,
>	IS_NULLABLE					VARCHAR(3)
>)
>
>INSERT INTO #MyDBTableInfo
>SELECT
>	TABLE_SCHEMA + '.' + TABLE_NAME AS TableName,
>	0 AS TableRowCount,
>	COLUMN_NAME,
>	ORDINAL_POSITION,
>	COLUMN_DEFAULT,
>	DATA_TYPE,
>	CHARACTER_MAXIMUM_LENGTH,
>	NUMERIC_PRECISION,
>	NUMERIC_PRECISION_RADIX,
>	NUMERIC_SCALE,
>	IS_NULLABLE
>FROM INFORMATION_SCHEMA.COLUMNS
>
>DECLARE MyDBTableInfoCUR CURSOR FOR
>SELECT DISTINCT TableName
>FROM #MyDBTableInfo
>OPEN MyDBTableInfoCUR
>FETCH NEXT FROM MyDBTableInfoCUR INTO @TableName
>WHILE @@FETCH_STATUS = 0
>BEGIN
>	SET @RowCount = (SELECT COUNT (*) FROM @TableName)
>
>	UPDATE #MyDBTableInfo
>		SET TableRowCount = @RowCount WHERE TableName = @TableName
>
>	FETCH NEXT FROM MyDBTableInfoCUR INTO @TableName
>END
>CLOSE MyDBTableInfoCUR
>DEALLOCATE MyDBTableInfoCUR
>
>
>SELECT * FROM #MyDBTableInfo
>
>

You can't use variable in FROM clause. To do this you should use so called Dynamic SQL.
Grrr, CURSOR and Dynamic SQL!

DECLARE @TableName varchar(8000)
DECLARE @SQL       nvarchar(4000)
DECLARE @RowCount  int
SELECT @TableName = MIN(TableName) FROM #MyDBTableInfo
WHILE @TableName IS NOT NULL
      BEGIN
          SET @SQL = 'SELECT @RecCount = COUNT(*) FROM '+ @TableName'
          sp_executesql @SQL, N'@RecCount int OUTPUT', @RecCount = @RowCount OUTPUT
          UPDATE #MyDBTableInfo
                 SET TableRowCount = @RowCount WHERE TableName = @TableName
          SELECT @TableName = MIN(TableName) FROM #MyDBTableInfo WHERE TableName > @TableName
      END

NOT TESTED AT ALL, but at least there is no cursor here :-)