DECLARE @TName VARCHAR(MAX);
DECLARE @Cnt VARCHAR(MAX);
DECLARE TABLENAME CURSOR
FOR
SELECT TNAME
FROM TABLENAME
WHERE TYPE = 'L';
OPEN TABLENAME;
FETCH NEXT FROM TABLENAME INTO @TName;
WHILE @@FETCH_STATUS = 0
BEGIN
SET NOCOUNT ON;
SELECT @Cnt = COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @TName;
PRINT 'Table : ' + @TName + ' (' + @Cnt + ')';
FETCH NEXT FROM TABLENAME INTO @TName;
END;
CLOSE TABLENAME;
DEALLOCATE TABLENAME;
DECLARE @Cnt VARCHAR(MAX);
DECLARE TABLENAME CURSOR
FOR
SELECT TNAME
FROM TABLENAME
WHERE TYPE = 'L';
OPEN TABLENAME;
FETCH NEXT FROM TABLENAME INTO @TName;
WHILE @@FETCH_STATUS = 0
BEGIN
SET NOCOUNT ON;
SELECT @Cnt = COUNT(*)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @TName;
PRINT 'Table : ' + @TName + ' (' + @Cnt + ')';
FETCH NEXT FROM TABLENAME INTO @TName;
END;
CLOSE TABLENAME;
DEALLOCATE TABLENAME;
No comments:
Post a Comment